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

79 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
dodoism1135891dodoism
dodoes85716102dodoes_
dodoisms1244522dodoisms
dodos75819392dodo_s_
bodkin1338923bodki_n
bodkins1438313bodkins
codein94916723codei_n
codeins103715483codeins
codfish1637163codfish
codlin94516443codli_n
codlins104116243codlins
codon86522853codo__n
codons96119463codons_
cojoin1539503cojoi_n
cojoins1638993cojoins
dadaism1136443dadaism
dadaist9310103dadaist
dadoes85616533dadoes_
dadoing1038523dadoing
dados75522433dado_s_
didoes85716963didoes_
didos76820813dido_s_
dobbin11339523dobbi_n
dobbins12379533dobbins
dodges96119083dodges_
dodgier10388243dodgier
dodgiest11308713dodgiest
dodging11299063dodging
dodo66024913dodo___
dogdoms1295423dogdoms_
dogfish15226763dogfish
doggish13237533doggish
dojos135111793dojo_s_
dollish11610093dollish
dolors75115313dolors_
doltish11118733doltish
domain9511323domai_n
domains10510873domains
donnish11187633donnish
donors75115793donors_
doodies94218773doodies
doodoos9107623doodoos_
dooms85321343do_oms_
doors65022133do_ors_
dormin9312313dormi_n
dormins10311273dormins
dovish1338103do_vish
dowdyish1952833dowdyish
dudish1148313dud_ish
godown1136033godo_wn
godowns1234673godowns
goodish1237963goodish
hoboism1446623hoboism
hoddin11369943hoddi_n
hoddins12289373hoddins
iodin64419353iod_i_n
iodins74216523iod_ins
iodise74214943iod_ise
iodism93611133iod_ism
iodopsin1143333iodopsin
iodous7311503iodous_
judoist1545633judoist
locoism1156793locoism
modish123813543mod_ish
nodose738883nodo_se
nodous7711333nodous_
oboist8312683_oboist
oddish11107653_oddish
odist6421913_od_ist
odors64514283_odors_
oodlins83210513oodlins
pocosin1169643pocosin
poloist91016323poloist
sodomist1157633sodomist
sodoms989673sodoms_
soloist7915893soloist
vodoun1036233vodo_un
vodouns1134763vodouns
vodous1038603vodous_

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 Filter1786911340270.486367677.0
2DLD Change Limit134027796.14021828.5
3Display Results79790.0302633.3
 (SQL Overall)178691796.65626846.6
 
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.