Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “moires” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

117 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
moires891563(None) 
mires75640881m_ires
moire71017311moire_
mores76249641mo_res
armoires1057622armoires
boites84322702boites
bores76448252bo_res
cires74932912_cires
coirs75221052coir_s
cores76361852co_res
dories75232362dories
empires1139852empires
fires85740752_fires
fores85847102fo_res
goitres8389562goitres
gores65740372go_res
hires86134342_hires
hoises94823672hoises
ires45639282__ires
koines10415732koines
lores55045402lo_res
lories64933042lories
madres93718182madres
mailes84329112mailes
mairs76228292mair_s
maizes175115732maizes
mares76457632m_ares
matres84522232matres
mbiras1077142mbiras
meres75143572m_eres
metres85121562metres
mikes115129892m_ikes
miles74645072m_iles
mimes95732022m_imes
mines75651952m_ines
mioses84318852mioses
mire66748222m_ire_
mired85729222m_ired
mirex146816622m_irex
mirks115122142m_irks
mirs66940562m_ir_s
mises74740562m_ises
mites75141802m_ites
mitres83922072mitres
mixes147224402m_ixes
mobiles112813122mobiles
modes85537412mo_des
moidores1156332moidores
moiled94318862moiled
moiler84017262moiler
moilers93615202moilers
moils76125742moi_ls
moira71012012moir_a
moirai886912moirai
mojoes15399522mojoes
mokes114631032mo_kes
moles74747922mo_les
molies84429512molies
momes95134472mo_mes
mondes94322352mondes
monies83233162monies
montes84226932montes
moored93814172moored
moors74923142moor_s
mopers104220372mopers
mopes95134982mo_pes
moras76438762mo_ras
more67154522mo_re_
morel75729092mo_rel
morels84820012mo_rels
morns75527442mo_rns
morris83814722morris
morros83714672morros
mors65950062mo_r_s
morse76032702mo_rse
morts75533562mo_rts
moshes115222872moshes
mosses85527682mosses
motes75944002mo_tes
motiles93317432motiles
motives123611892motives
mottes85523692mottes
moues75732842mo_ues
mourns84111012mourns
mouses85531422mouses
movers115117192movers
moves106128422mo_ves
movies115118452movies
mowers113219402mowers
moxies154317402moxies
mures75937212m_ures
murres85019042murres
noirs55615462noir_s
noises65021852noises
ogres65818632_ogres
ombres103911132ombres
ores46056682_o_res
poises84226542poises
pores75849032po_res
quires154015732quires
shires95225572shires
sires55945372_sires
soiree62919482soiree
soirees72411642soirees
sores55454282so_res
spires84628112spires
tires55437492_tires
toiles63923512toiles
tores55352672to_res
tories65435882tories
umpires1137812umpires
vires84529682_vires
voices114414012voices
voiles94616442voiles
wires86034912_wires
yores85031322yo_res
zaires1539702zaires

Search took 7 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter178691825510.1101624463.6
2DLD Change Limit825511175.61014715.0
3Display Results1171170.0761539.5
 (SQL Overall)1786911175.79630830.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.