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

106 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
cerumens123576(None) 
cerumen1147761cerumen_
cerement12315132cerement
cerements13411452cerements
cermets1139712cer_mets
ceruleans1192922ceruleans
ceruses93716232ceruse_s
germens1078622ger_mens
hegumens1444302hegumens
rumens83611812__rumens
acumens1136953_acumens
albumens1244143albumens
berimes115216643berime_s
bermes106023003ber_me_s
bitumens1243523bitumens
brumes106417073_brume_s
calumets1236283calumets
caramels1238803caramels
careens94514703car_eens
carmen104019343car_men_
cement103321663ce__ment
cements112714223ce__ments
ceramals1246513ceramals
ceramics1446803ceramics
cerates95428253cerate_s
ceratins102818733ceratins
ceremony1544313ceremony
ceres75540013cer__e_s
cereus85215523cer__eus
cereuses1049243cereuse_s
cerises94722253cerise_s
cerites94823433cerite_s
ceriums1139473cerium__s
cermet10321153cer_me_t
certes84623083cer_te_s
cerulean1053773cerulean
ceruminous1443193ceruminous
ceruse83914523ceruse__
chromes142914933chrome_s
columels1244813columels
columns1136473colum_ns
cormels113813373cor_mels
corulers1039773corulers
cravens124010113c_ravens
creamers124111303creamers
cremes104517993c_reme_s
crewmen1436373crewmen_
crimes105521583c_rime_s
cruces105117543c_ruce_s
crudes96218623c_rude_s
cruets85314953c_ru_ets
crumbers14338243c_rumbers
crumbs12409233c_rum_bs
crumpets14335943c_rumpets
crumps124514343c_rum_ps
cruses88127713c_ruse_s
crusets93811043c_rusets
cruxes154911563c_ruxe_s
cumins103314933c__umins
duramens1195153duramens
energumens1352793energumens
erumpent1245453_erumpent
examens1637193_examens
ferment12315573fer_ment
ferments13311473fer_ments
ferules103112723ferule_s
foramens1337823foramens
germans1079473ger_mans
germen9612313ger_men_
grumes94415553_grume_s
heaumes1237423heaume_s
hegumen1355463hegumen_
hegumene1443983hegumene
hegumenes1544033hegumenes
hegumenos1542583hegumenos
hegumeny1742903hegumeny
herdmen13238453herdmen_
kermes124616123ker_me_s
kermess13396223ker_mess
kerogens1345763kerogens
legumes1036633legume_s
legumins1144993legumins
lumens85013973__lumens
mermen10813813mer_men_
neumes83112623ne_ume_s
perfumers1683713perfumers
perfumes1555893perfume_s
perukes133210113peruke_s
perusers10328803perusers
peruses94018163peruse_s
regimens11469233regimens
relumes9612513relume_s
reruns66413743reru__ns
resumers1038083resumers
resumes9313373resume_s
rumen74419503__rumen_
semens84616963se__mens
sermons9311783ser_mons
serums83916303serum__s
tegumen10105423tegumen_
tegument1177523tegument
teguments1265453teguments
termers95414503ter_mers
terreens8246533terreens
vermes115019143ver_me_s
xeruses143010753xeruse_s

Search took 9 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.1561145455.1
2DLD Change Limit1461621067.89018525.0
3Display Results1061060.0303533.3
 (SQL Overall)1786911068.07622126.2
 
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.