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

160 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
deadman1123842(None) 
beadman12249151beadman
deadmen11248571deadmen
deadpan11225231deadpan
headman13229631headman
leadman10237841leadman
adman84517902__adman
badman113813842_badman
beadmen12299452beadmen
beadsman1355612beadsman
daman84821162d_a_man
deaden83714322dead_en
deadpans12205172deadpans
decuman1236572decuman
deskman1444322deskman
desman9311692de_sman
drayman1335432drayman
headmen13259512headmen
headsman1446352headsman
herdman13238422herdman
leadmen10277902leadmen
leadsman1145242leadsman
madman113712382_madman
meatman1137902meatman
reedman1037722reedman
seaman84015902sea_man
seedman1037372seedman
admen84516183__admen
aidman92410623_aidman
ataman81013063ata_man
atman75520143__atman
axman144813183__axman
badmen114613833_badmen
bagman114613813_bagman
barman103519703_barman
batman105214063_batman
bayman133712703_bayman
beadsmen1385883beadsmen
bedamn1137813bedam_n
bedeman12168843bedeman
bedpan1137583be_dpan
bellman1137183bellman
birdman1236673birdman
boardman1344393boardman
boatman1147053boatman
bondman1238043bondman
cabman123812503_cabman
caiman103615663_caiman
carman103920743_carman
cayman133613213_cayman
chapman1637893chapman
dada66422443d_ad_a_
dadas75819863d_ad_as
daedal849083daed_al
daemon9279593d_aemon
daimen92210573d_aimen
daimon9259713d_aimon
damans94715983d_a_mans
damar84117733d_a_mar
dammar11438903d_ammar
damn75724323d_a_m_n
daysman1335053daysman
deacon9510423dea_con
dead65434243dead___
deadbeat1245803deadbeat
deadens93410693deadens
deader84220473dead_er
deadest93014883deadest
deadeye1245163deadeye
deadfall1343313deadfall
deadhead1444433deadhead
deadline10139053deadline
deadly113811473dead_ly
deads75726913dead__s
deafen10389673dea_fen
dean56039483de___an
deathsman1543003deathsman
decadal1137243decad_al
decimal1238083decimal
dedal75719023de_d_al
dedans85915073de_d_ans
deewan10267553de_ewan
demand104314253de__mand
demean9510563de_mean
demon86520313de__mon
dendron947653dendron
deodand1035713deod_and
deodar837713deod_ar
derma84918513de_rma_
dermal93614343de_rmal
dermas94116813de_rmas
deskmen1435023deskmen
desmans1039003de_smans
dewan95718043de__wan
dextran1586163dextran
dharma1276103dharma_
dharmas1356503dharmas
diamin9312513dia_min
dolman95312403d_olman
doorman1037063doorman
dragoman1244653dragoman
drama85117413dra_ma_
dramas95814653dra_mas
draymen1335233draymen
dustman1044683dustman
flagman13186173flagman
freedman1444143freedman
gagman103811243_gagman
gasman92911743_gasman
german9611983ge_rman
goodman1135933goodman
headband1544843headband
headland1345613headland
headpin1336003headpin
headsmen1465983headsmen
headway1745553headway
herdmen13238453herdmen
herdsman1465643herdsman
hetman112510603he_tman
landman1038923landman
lawman11289053_lawman
layman113511303_layman
leaden74515223lead_en
leadsmen1154793leadsmen
legman949653le_gman
leman75622603le__man
lensman937563lensman
madmen113511743_madmen
meatmen1138243meatmen
median94117543me_dian
merman10513853me_rman
messman1137283messman
newsman1245503newsman
pearmain1245823pearmain
penman10312323pe_nman
radian74117273_radian
ragman94013713_ragman
readmit1039823readmit
readorn8310463readorn
redan66125013re_d_an
reedmen1038333reedmen
reman75730153re__man
rodman949713_rodman
sandman10310173sandman
seamen84518563sea_men
seawan94111223sea_wan
sedan65620423se_d_an
seedmen1037683seedmen
seedsman1144893seedsman
shaman113314273sha_man
spearman1244943spearman
swagman1334913swagman
taxman15328613_taxman
teleman959573teleman
vanman1139793_vanman
wadmal1237283_wadmal
woodman1336313woodman
yardman1335913yardman
yeggman1442923yeggman
yeoman1138823ye_oman

Search took 10 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.1531167915.0
2DLD Change Limit1340271609.22014536.6
3Display Results1601600.1101454.5
 (SQL Overall)1786911609.48318843.3
 
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.