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 “mirror” with Change Limit: [1] [2] [3]

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

264 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
mirror84800(None) 
mirrors938621mirrors
error53712232_error
horror988722horror
marrer83716672marrer
marron83717542marron
marrow112812602marrow
micro94715992micro_
micron103714282micron
micros104115362micros
mikron12318502mikron
minor74920062mi_nor
mirador1046502mirador
mirier83918362mirier
mirker123712692mirker
mirrored1145772mirrored
morro73216952morro_
morros83714672morros
morrow113510092morrow
terror63811732terror
airdrop1044423airdrop
airer54927893ai_rer
airier64619363airier
airport9511383airport
arbor74818113_arbor
ardor64617863_ardor
armor75118053_armor
arrow83414883_arrow
barrow114512763barrow
bicron103710773bicron
birder94915493birder
birler85715083birler
biro66131213bi_ro_
biros75325133bi_ros
birr66022363bi_r_r
birred94713203birred
birrs74917103birr_s
borrow114310723borrow
brrr65312293_brr_r
burrer83718473burrer
burro75018493burro_
burros85114993burros
burrow114610803burrow
carrom10513403carrom
carrot8423123carrot
cirri7710723cirr_i
cirrose937473cirrose
cirrous93111063cirrous
cirrus8349173cirrus
citron83112983citron
cruor7310453_cruor
cursor84110293cursor
direr64927073di_rer
diuron738573diuron
emperor1155483emperor
errors63311313_errors
farrow12309973farrow
fervor1235643fervor
firer811229253fi_rer
firmer114712443firmer
firrier103410133firrier
firry115713533firr_y
furor8312393_furor
furrow12427743furrow
garron73113493garron
girder84312063girder
giro55828633gi_ro_
giron66118993gi_ron
giros65722653gi_ros
harbor11410723harbor
harrow122610773harrow
hirer85423123hi_rer
horrors1078693horrors
ichor1039483_ichor
improv1344643improv
inro45920793_inro_
iron46728463_i_ron
juror1239563_juror
karroo10410013karroo
lictor83610863lictor
liquor1534203liquor
lirot5430033li_rot
macro94718173macro_
macron103615673macron
macros104017013macros
mahzor2035113mahzor
major145212923m_ajor
manor78023933m_anor
marker124420393marker
markhor1635463markhor
marmot10318743marmot
maroon83118203maroon
marram10313883marram
marred95421043marred
marrers93414313marrers
marrier93817523marrier
marrons93216973marrons
marrows122911823marrows
marrowy15236083marrowy
marry104821693marr_y
martyr1135693martyr
matron83918313matron
mayor106616623m_ayor
mentor8414363mentor
mercer105214203mercer
merer75126233m_erer
merger95016483merger
merlon83012353merlon
merlot83217613merlot
merrier92612303merrier
merry104721493merr_y
meteor84910073meteor
metro74718803metro_
metros84217803metros
miaou7513083mi_aou
miaow1058353mi_aow
micra96214973micr_a
microbar1445893microbar
microbe1338663microbe
microhm1646123microhm
microns113814783microns
midair937993midair
midiron1046003midiron
midrib1138243midrib
mignon937953mignon
migrator1147873migrator
mihrab1335523mihrab
mikra114610313mikr_a
mikrons13428413mikrons
mikvos1554023mikvos
mikvot1556763mikvot
milder93818453milder
miler75733063mi_ler
milker124814323milker
miller84625413miller
milo65536103mi_lo_
milord999573milord
milos75428013mi_los
milter84921233milter
mimbar1297493mimbar
mimeo96018683mimeo_
mimeos104511543mimeos
mimer94825763mi_mer
mincer104017363mincer
minder94822503minder
miner76933543mi_ner
minion83416243minion
minnow1135583minnow
minors85117103minors
minter84425103minter
mir57046773mi___r
miradors1146853miradors
mirage92313653mirage
mire66748233mi_r_e
mired85729223mi_red
mires75640883mi_res
mirex146816623mi_rex
miri66730373mi_r_i
mirin75023153mi_rin
miring93723803miring
mirins83918903mirins
mirk106729503mi_r_k
mirkier13319053mirkier
mirks115122143mi_rks
mirky146315523mi_rky
mirroring1246193mirroring
mirs66940573mi_r_s
mirth106418893mi_rth
mirths114912993mirths
miry96326753mi_r_y
mirza16410443mi_rza
mirzas1738183mirzas
misdo85413183misdo_
misdoer1048633misdoer
miser75430403mi_ser
misform1437513misform
misgrow1344433misgrow
miso67229903mi_so_
misos76523293mi_sos
missort9314653missort
mister84728563mister
misword1338413misword
miter75734793mi_ter
miterer92511333miterer
mither114218563mither
mitier83620673mitier
mitral81314323mitral
mitre75522423mitr_e
mitred94414343mitred
mitres83922073mitres
mixer145017643mi_xer
moor66628553m__oor
mor56855003m___or
morion86217733morion
moron76925423m_oron
morrion959003morrion
morris83814733morris
morrows12318723morrows
mortar83812043mortar
motor75317293m_otor
mucor94011943m_ucor
mucro94513723mucro_
murder93613783murder
murker123715243murker
murmur1034853murmur
murr65225133m_ur_r
murra74519083murr_a
murras84916013murras
murre74821073murr_e
murres85019043murres
murrey114312263murrey
murrha11366453murrha
murrs75521303murr_s
murry105120233murr_y
myrrh1337093myrr_h
myrrhs1443603myrrhs
narrow9269143narrow
nimrod934873nimrod
nitro54914353nitro_
nitros64214123nitros
omicron1165063omicron
omikron1353173omikron
parlor8312673parlor
parrot8320663parrot
perron83216623perron
pierrot948833pierrot
pirog83913673pi_rog
prior74316173_prior
pyrrol1136273pyrrol
rigor62714053ri_gor
sartor6313883sartor
signor73510353signor
sirdar7269103sirdar
sirra54416323sirr_a
sirrah9379753sirrah
sirras63814863sirras
sirree64017343sirree
smirker13327423smirker
sordor7310223sordor
sorrow9339443sorrow
stirrer7338233stirrer
termor84412513termor
terrors73112213terrors
tiro46832363ti_ro_
tiros54524893ti_ros
torpor839193torpor
turgor736863turgor
viator93211833viator
victor113210673victor
vigor92612423vi_gor
vireo84816453vireo_
vireos94212453vireos
virion9310683virion
visor82512833vi_sor
vizor173010093vi_zor
warrior1045363warrior
wirer85124953wi_rer
wirier94215553wirier
wirra83210823wirr_a
yarrow12287933yarrow
yirr76513573yi_r_r
yirred10426963yirred
yirrs8469193yirr_s
zircon1754953zircon

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 Filter1786911127160.376475242.0
2DLD Change Limit1127162645.65619928.6
3Display Results2642640.0932838.7
 (SQL Overall)1786912646.12529174.0
 
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.