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

121 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
albumen113524(None) 
albumens1244141albumens
albumin1145561albumin
acumen1049012a_cumen
album92312652album__
albumins1245352albumins
albums10198272album_s
almsmen1144582almsmen
alumin8513542al_umin
clubmen1334252clubmen
lumen75220902_l_umen
abdomen1237023abdomen
abluent939623ablu_ent
abluted10188363abluted
abuse77119563a_buse_
abused95614273a_bused
abuser85413683a_buser
abuses85119103a_buses
abutment1247223a_butment
acumens1136953a_cumens
admen84516183a__dmen
adwomen1345683adwomen
agnomen1036763agnomen
aidmen92610373a_idmen
airmen82612353a_irmen
alarmed1037743alarmed
alarumed1143323alarumed
albite8313313albite_
albites9313203albites
albumose1272633albumose
albumoses1392853albumoses
aldermen1145043aldermen
aleuron757383aleuron
algum82711763algum__
algums9208043algum_s
alien56425583al__ien
aliment9316703al_iment
allude73910903allude_
alluded9327093alluded
alludes83610333alludes
allure63012943allure_
allured8299173allured
allurer7348433allurer
allures72913113allures
alme65832163al__me_
almeh106214553al__meh
almes75126543al__mes
almsman1145093almsman
almuce10348213almuce_
almuces11316823almuces
almude9399933almude_
almudes10418263almudes
aludel747863al_udel
alum65227613al_um__
alumina9510053al_umina
alumine9412693al_umine
alumins9512983al_umins
alumna857343al_umna
alumni856753al_umni
alums75720603al_um_s
amen66733153a___men
arbute8311043arbute_
arbutean1043003arbutean
arbutes939703arbutes
argument1158903argument
ashmen1168173a_shmen
assume897563assume_
assumed1065293assumed
assumer965363assumer
assumes967163assumes
auburn836213aubu_rn
automen939653automen
autumn836013autum_n
axemen1547493a_xemen
axmen145112273a__xmen
bitumen1134503bitumen
blume95619893bl_ume_
blumed114313643bl_umed
blumes105917793bl_umes
busmen1039893__busmen
cabmen123610653cab_men
calumet11313293cal_umet
cerumen1147763cerumen
clubman1344023clubman
dalesmen1146203dalesmen
flagmen13226913flagmen
flamen115215993fl_amen
flehmen1534913flehmen
flume106021173fl_ume_
flumed124915263fl_umed
flumes115119733fl_umes
flymen14387773fl_ymen
gleemen1035723gleemen
glume85120463gl_ume_
glumes94516813gl_umes
gluten74210753gl_uten
hegumen1355463hegumen
illume8298223illume_
illumed10285863illumed
illumes9327673illumes
landmen1038553landmen
lawmen11308593_lawmen
laymen113010843_laymen
legmen939343_legmen
limen75426033_l_imen
louden73711793_louden
loupen84510293_loupen
lumens85013973_l_umens
lumpen104010663_l_umpen
numen74216793__numen
ovalbumin1691043ovalbumin
plowmen1434883plowmen
plume94819463pl_ume_
plumed114412883pl_umed
plumes104318133pl_umes
plumpen13276403pl_umpen
rumen74419503__rumen
salesmen1047253salesmen
talesmen1047013talesmen
tallymen1343523tallymen
tegumen10105423tegumen

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.390458182.1
2DLD Change Limit1340271216.39020974.5
3Display Results1211210.0462630.4
 (SQL Overall)1786911216.82626178.0
 
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.