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

100 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
decorum124694(None) 
decorums1344991decorums
decor84717572decor__
decorous1138852decorous
decors94017772decor_s
deform1259622defor_m
deworm1249532dewor_m
indecorum1452112indecorum
aecium10410423aec_ium
beworm1339993bewor_m
cecum11611843cec__um
centrum1168603centrum
corium10315723__corium
corm85735383__cor_m
decagram1444653decagram
decare93919153decar_e
decares102818533decares
decern91310953decer_n
decerns10119053decerns
decidua1144493decidua
decigram1445353decigram
declaim1247363declaim
deco76125973deco___
decoct11313783deco_ct
decocts1237833decocts
decode104414743deco_de
decoded123212383decoded
decoder113712293decoder
decodes113914983decodes
decolor1087033decolor
decolour1185013decolour
decorate11315193decorate
decos85522123deco__s
decoy115716313deco__y
decoyed14358333decoyed
decoyer13348683decoyer
decoys123911283deco_ys
decree93117783dec_ree
decrown13206053decrown
decry115514353dec_r_y
decurve1335583decurve
decury1277963decur_y
defoam1238563defo_am
defocus1335283defocus
deforce13267243deforce
deforms1337803deforms
degerm1037893deger_m
degum94711903de__gum
dehorn10439653dehor_n
dehorns11428363dehorns
dehort104618103dehor_t
dehorts11379773dehorts
deiform1336693deifor_m
delirium1146583delirium
deperm1139363deper_m
deport94922393depor_t
deports105012883deports
derm76031893de__r_m
desorb95210203desor_b
desorbs10437713desorbs
detour778193deto_ur
detours858043detours
devour1076703devo_ur
devours1166643devours
devout10712993devo_ut
deworms1338033deworms
dictum1136863dic_tum
diestrum1145363diestrum
dorm76834633d__or_m
dorsum947623d__orsum
doum76226673d__o_um
drum76521593d___rum
durum8513203d__urum
ecru65819533_ec_ru_
ecrus75113863_ec_rus
electrum1245213electrum
enorm74415643_enor_m
estrum81810513_estrum
ferrum1147453fe_rrum
forum108318763__forum
indecorums1561433indecorums
jorum145513743__jorum
meconium1447313meconium
oestrum9177783oestrum
pelorus939273pelorus
plectrum1453953plectrum
quorum1736023_quorum
record96117433recor_d
records105213923records
recork126315493recor_k
recorks134813023recorks
recoup10810373reco_up
rectum103411283rec_tum
reform11312713refor_m
sacrum103910143sac_rum
scrum95418203_sc_rum
serum75223473se__rum
spectrum1444073spectrum
tectum10328603tec_tum
tetotum9134613tetotum

Search took 8 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.406440125.6
2DLD Change Limit1340271007.40618097.1
3Display Results1001000.0303333.3
 (SQL Overall)1786911007.84222786.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.