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

102 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
dodoism113589(None) 
dodoisms1244521dodoisms
dadaism1136442dadaism
dodoes85716102dodoes_
dodos75819392dodo_s_
hoboism1446612hoboism
iodism93611132iod_ism
locoism1156792locoism
bogyism1545213bogyism
bossism1136063bossism
codfish1637163codfish
codons96119463codons_
colorism122112433colorism
cosmism1337013cosmism
dadaisms1245123dadaisms
dadaist9310103dadaist
dadoes85616533dadoes_
dadoing1038523dadoing
dados75522433dado_s_
dandyism1543943dandyism
deism84116033__deism
demonism1359453demonism
didoes85716963didoes_
didos76820813dido_s_
dioecism1344843dioecism
dodgem116710033dod_gem
dodgems12576443dodgems
dodges96119073dodges_
dodgier10388243dodgier
dodgiest11308713dodgiest
dodging11299063dodging
dodo66024913dodo___
dogdom1186363dogdo__m
dogdoms1295423dogdoms_
dogfish15226763dogfish
doggish13237533doggish
dojos135111793dojo_s_
dollish11610093dollish
dolors75115313dolors_
doltish11118733doltish
donnish11187633donnish
donors75115793donors_
doodies94218773doodies
doodoos9107623doodoos_
doom76430073do_o__m
dooms85321343do_oms_
doors65022133do_ors_
dovish1338103do_vish
dowdyish1952833dowdyish
dualism1049163dualism
dudish1148313dud_ish
echoism1447363echoism
egoism977473_egoism
eonism83213533eo_nism
faddism14356723faddism
fideism1335773fideism
fogyism1643943fogyism
goodish1237963goodish
hedonism1446443hedonism
heroism12311013heroism
hoboisms1545563hoboisms
holism113713743ho_lism
hoodooism1553273hoodooism
idolism1037273ido_lism
iodise74214943iod_ise
iodisms10308483iod_isms
iodous7311493iodous_
judoist1545633judoist
locoisms1256143locoisms
lookism1335913lookism
mobbism1535053mobbism
modish123813543mod_ish
momism93410353mo_mism
monism104016313mo_nism
moronism1249323moronism
nodose738883nodo_se
nodous7711323nodous_
nomism103010953no_mism
nudism9357913nud_ism
obiism1036363_obiism
oboist8312683_oboist
oddish11107653_oddish
odist6421913_od_ist
odium83413033_od_ium
odors64514273_odors_
ogrism937913_ogrism
podium112911913pod_ium
poloist91016323poloist
porism104518063po_rism
robotism1285953robotism
rowdyism1752153rowdyism
sadism94113493sad_ism
sodium92111443sod_ium
sodom8814903sodo__m
sodomist1157633sodomist
sodoms989663sodoms_
soloist7915893soloist
sophism1437863sophism
toadyism1443673toadyism
tourism939423tourism
vodous1038593vodous_
voodooism1551913voodooism

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.1601116818.8
2DLD Change Limit1340271026.56020430.9
3Display Results1021020.0333090.9
 (SQL Overall)1786911026.75326461.0
 
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.