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

235 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
deadmen1124857(None) 
beadmen12299451beadmen
deaden83714321dead_en
deadman11238421deadman
headmen13259511headmen
leadmen10277901leadmen
admen84516182__admen
badmen114613832_badmen
beadman12249152beadman
beadsmen1385882beadsmen
daimen92210572d_aimen
deadens93410692dead_ens
deader84220472dead_er
deadpan11225232deadpan
deafen10389672dea_fen
deskmen1435022deskmen
draymen1335232draymen
headman13229632headman
headsmen1465982headsmen
herdmen13238452herdmen
leaden74515222lead_en
leadman10237842leadman
leadsmen1154792leadsmen
madmen113511742_madmen
meatmen1138242meatmen
reedmen1038332reedmen
seamen84518562sea_men
seedmen1037682seedmen
adman84517903__adman
aidmen92610373_aidmen
amen66733153__a_men
axmen145112273__axmen
badman113813843_badman
bagmen115412533_bagmen
barmen105418533_barmen
batmen104414303_batmen
baymen134212003_baymen
beaded104922423bead_ed
beader94623793bead_er
beadier103513913beadier
beadle93314683beadle_
beadles103414733beadles
beadsman1355613beadsman
beamed115720733bea_med
beaten84617063bea_ten
bedamn1137813bedam_n
bedemen12910183bedemen
bellmen1138143bellmen
bemadden1443113bemadden
birdmen1235833birdmen
boardmen1344073boardmen
boatmen1146913boatmen
bondmen1237893bondmen
cabmen123610653_cabmen
carmen104019343_carmen
cerumen1147763cerumen
chapmen1637283chapmen
dadoed9449903d_adoed
dadoes85616533d_adoes
daemon9279593d_aemon
daimon9259713d_aimon
daman84821163d_a_man
dame77140313d_a_me_
dames85435853d_a_mes
dammed124214793d_ammed
dammer114317933d_ammer
damn75724323d_a_m_n
dampen114310593d_ampen
darken114013443d_arken
daven94916473d_a_ven
dawen95413723d_a_wen
daysmen1335083daysmen
deacon9510423dea_con
dead65434243dead___
deadbeat1245803deadbeat
deadened1137233deadened
deadener1036743deadener
deadest93014883deadest
deadeye1245163deadeye
deadeyes1344563deadeyes
deadhead1444433deadhead
deadlier1036863deadlier
deadline10139053deadline
deadly113811473dead_ly
deadness1039233deadness
deadpans12205173deadpans
deads75726913dead__s
deafens11317253dea_fens
deafer104114813dea_fer
deaired9411533deaired
dealer74122143dea_ler
dean56039483dea___n
deaned84620453dea_ned
dearer74822803dea_rer
dearie73319813dearie_
dearies83526273dearies
deashed123411303deashed
deashes113313903deashes
deathsmen1543033deathsmen
deave95022333dea_ve_
deaved114916553dea_ved
deaves105319533dea_ves
debarment1447793debarment
decade104216163decad_e_
decadent1249003decad_ent
decades113615513decad_es
decuman1236573decuman
deeded94615543deed_ed
deedier93011593deedier
deemed104713063de_emed
deepen9339193de_epen
defame123212433defame_
defamed14309833defamed
defamer132710323defamer
defames132812253defames
degame102713183degame_
degames113312623degames
delime9314043delime_
delimed11310723delimed
delimes10314193delimes
deme76536283de__me_
demean9510563de__mean
dement93825153de__ment
demes86032693de__mes
demon86520313de__mon
dendron947653dendron
denimed1159233denimed
denizen1737663denizen
deskman1444323deskman
desman9311693de_sman
diadem1037583diad_em
diademed1344153diademed
diadems1135393diadems
diamin9312523dia_min
dolmen93911373d_olmen
doormen1036753doormen
dragomen1245013dragomen
drammed13378073drammed
drayman1335433drayman
dreaded103612023dread_ed
dreamed114310633drea_med
dreamer104110843drea_mer
dudeen857173d_udeen
duramen1096903duramen
dustmen1035773dustmen
eaten55323053_ea_ten
examen1538283_examen
flagmen13226913flagmen
flamen115215993fla_men
freedmen1444553freedmen
gagmen103910413_gagmen
gasmen93111563_gasmen
germen9612313ge_rmen
gladden10376313gladden
goodmen1135623goodmen
headed114020473head_ed
headend12398363head_end
header104422543head_er
headier113212953headier
headpin1336003headpin
headset11312603headset
headsman1446353headsman
hearken14338023hearken
hearten102411753hearten
heathen133410893heathen
heaume1137543heaume_
heaumes1237423heaumes
heaven123912603hea_ven
hegumen1355463hegumen
herdman13238423herdman
herdsmen1464833herdsmen
laden65022193_lad_en
landmen1038553landmen
lawmen11308593_lawmen
laymen113010843_laymen
leaded84221543lead_ed
leadens83610983lead_ens
leader74824653lead_er
leadier83212723leadier
leadsman1145243leadsman
leaven95013073lea_ven
legmen939343le_gmen
lensmen937883lensmen
madden103912523_madden
madman113712383_madman
meatman1137903meatman
mermen10813813me_rmen
messmen1137393messmen
neaten64214543nea_ten
newsmen1235893newsmen
peahen113410133pea_hen
peasen84815963pea_sen
penmen10311493pe_nmen
ragmen93712183_ragmen
ramen75625193_ra_men
readded103310733readded
reader73628293read_er
readied93316623readied
readier83117423readier
readies83324713readies
readmit1039823readmit
readorn8310483readorn
reamed94326123rea_med
reamer84325213rea_mer
rearmed103912823rearmed
redden83613623re_dden
reedman1037723reedman
regimen104411573regimen
rodmen939713_rodmen
sadden83212403_sadden
sandmen1039413sandmen
seaman84015903sea_man
seamed94823883sea_med
seamer84223613sea_mer
seedman1037373seedman
seedsmen1144303seedsmen
semen75724103se__men
spearmen1234853spearmen
stamen84115943sta_men
swagmen1334973swagmen
taxmen15367443_taxmen
teamed95418593tea_med
tegmen988403te_gmen
tegumen10105423tegumen
telemen9310173telemen
vanmen1138403_vanmen
velamen1237123velamen
wadmel1235523_wadmel
weaken13349603wea_ken
weldment1445823weldment
woodmen1356053woodmen
yamen104115183_ya_men
yardmen1335423yardmen
yeggmen1442673yeggmen
yeomen1138183ye_omen

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 Limit1340272356.90619407.3
3Display Results2352350.0763092.1
 (SQL Overall)1786912357.38824186.7
 
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.