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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

85 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
midirons114588(None) 
midiron1046001midiron_
andirons948422andirons
gridirons1162572gridirons
microns113814782mi_crons
midnoons1144402midnoons
mikrons13428412mi_krons
minions93314622mini_ons
sadirons936022sadirons
vidicons1443862vidicons
ailerons849843ailerons
amidins103713103amidi__ns
andiron848283andiron_
bicrons113410473bi_crons
biotrons1037233biotrons
cistrons102710623cistrons
citrons92913223ci_trons
diatrons939613diatrons
diurons838823di_urons
eidolons944983eidolons
environs1144673environs
girons75014373__girons
gridiron1072513gridiron_
hadrons113314303had_rons
idioms956413_idi_oms
idiots768643_idi_ots
inions64417003_ini_ons
introns73515023_introns
irons55324133___irons
ladrons83813193lad_rons
liaisons844293liaisons
linurons846333linurons
macrons113514893m_acrons
madrona10288703mad_rona
madronas11288493mad_ronas
madrone102812663mad_rone
madrones112912283mad_rones
madrono10288743mad_rono
madronos11337543mad_ronos
maduros1036303maduro_s
madzoons20124773madzoons
malisons1048773malisons
marrons93216973m_arrons
matrons93517633m_atrons
medians103214213medi_ans
medicos12339833medico_s
micron103714283mi_cron_
micros104115363mi_cro_s
midairs1037203midair__s
midbrains1443713midbrains
middens11379383mid_dens
midis85923413midi___s
midnoon1044683midnoon_
midribs1235513mid_ribs
midriffs1742533midriffs
midtowns1443243midtowns
mignons1037863mi_gnons
mikron12318503mi_kron_
millions101712433millions
millruns1043643millruns
minikins14208323minikins
minion83416243mini_on_
minivans1345413minivans
mirins83918903m__irins
mirlitons1144113mirlitons
mirrors938623mi_rrors
misgrows1444963misgrows
missions10311903missions
moderns1037963moder_ns
monurons1037093monurons
morions94014643mori_ons
morons84919543m__orons
morrions1077673morrions
motions94215003moti_ons
omicrons1275193omi_crons
omikrons1462963omi_krons
pinions93413603pini_ons
sadiron836043sadiron_
silicons10107163silicons
smidgeons13272733smidgeons
vibrions1345093vibrions
vidicon1343783vidicon_
virions1039873viri_ons
visions10311023visi_ons
widgeons1343853widgeons

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 Filter1786911461620.1731032896.0
2DLD Change Limit146162856.23623438.4
3Display Results85850.0302833.3
 (SQL Overall)178691856.43927751.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.