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 “moire” 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.

127 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
moire7101732(None) 
mire66748231m_ire
moira71012021moira
moires8915631moires
more67154521mo_re
afire86215912afire
armoire938132armoire
boite74426322boite
bore66051332bo_re
cire65836372_cire
coir66327242coir_
coirs75221052coirs
core67263112co_re
dire56644142_dire
dore56353302do_re
empire1039322empire
fire76245592_fire
fore78351472fo_re
goitre7349002goitre
gore55744962go_re
hire75538962_hire
hoise85224772hoise
ire36943172__ire
koine9516482koine
kore85834162ko_re
lire47845292_lire
lore45850352lo_re
madre85720172madre
maigre9309162maigre
maile75232222maile
mair66133782mair_
mairs76228302mairs
maize164618562maize
mare64759332m_are
mbira977972mbira
mere67244442m_ere
metre74821302metre
mice87442232m_ice
mike105535292m_ike
mile66352572m_ile
mime85736402m_ime
mine67256172m_ine
mir57046772m_ir_
mired85729222m_ired
mires75640882m_ires
mirex146816622m_irex
miri66730372m_iri
mirk106729502m_irk
mirs66940572m_irs
miry96326752m_iry
mise66043582m_ise
mite66249412m_ite
mitre75522422mitre
mobile103613542mobile
mode75840302mo_de
moidore1056152moidore
moil65534092moi_l
moiled94318862moiled
moiler84017262moiler
moils76125752moils
moirai886912moirai
moist76033582moist
moke106234222mo_ke
mole66251832mo_le
moline84422032moline
mome85239352mo_me
monde85723142monde
monie75631652monie
monte75829772monte
moor66628552moor_
moored93814172moored
moors74923142moors
moory105115792moory
moose76327192moose
mope86838042mo_pe
moper94925922moper
mopier103914782mopier
mor56855002mo_r_
mora66641272mo_ra
morae75831192morae
morel75729092mo_rel
mores76249642mo_res
morn66237562mo_rn
morro73216952morro
mors65950062mo_rs
morse76032702morse
mort66758832mo_rt
moste75925082moste
mote67048082mo_te
motile83818342motile
motive113112142motive
motte75526972motte
moue65835572mo_ue
mourn77215012mourn
mouse77133002mouse
move96630722mo_ve
mover104220862mover
movie105319132movie
mower104523452mower
moxie144018122moxie
mure65941332m_ure
murre74821072murre
noir46722432noir_
noirs55615462noirs
noise55723732noise
ogre56320742_ogre
ombre94111802ombre
oorie53026362oorie
ore36661832_o_re
poise75127892poise
pore66451262po_re
quire144917132quire
shire84727132shire
sire46150412_sire
soiree62919482soiree
sore47059532so_re
spire75828692spire
tire46143352_tire
toile54626492toile
tore47359322to_re
umpire1047892umpire
voice104915322voice
voile84719722voile
wire75839812_wire
wore77144672wo_re
yore76335942yo_re
zaire14311992zaire

Search took 2 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 Filter178691538000.313570897.8
2DLD Change Limit538001271.40638264.6
3Display Results1271270.0462760.9
 (SQL Overall)1786911271.765101241.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.