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

259 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
sandmen103941(None) 
landmen1038551landmen
sandman10310171sandman
admen84516182_a_dmen
aidmen92610372_aidmen
badmen114613832ba_dmen
bandsmen1356452bandsmen
bondmen1237892bondmen
handymen1744982handymen
hangmen1337372hangmen
landman1038922landman
landsmen1156602landsmen
madmen113511742ma_dmen
sadden83212402sa_dden
sagamen10127502sagamen
sanded84920612sand_ed
sander74828532sand_er
sandier84017842sandier
seedmen1037682seedmen
soundmen1145232soundmen
vanmen1138402van_men
yardmen1335422yardmen
abdomen1237023_abdomen
acumen1049013_acumen
adman84517903_a_dman
agnomen1036763agnomen
aidman92410623_aidman
airmen82612353_airmen
amen66733153_a__men
anime75423203_anime_
animes84719593_animes
ashmen1168173_ashmen
axemen1547493_axemen
axmen145112273_a_xmen
badman113813843ba_dman
bagmen115412533ba_gmen
banded105223173band_ed
bander93928223band_er
bandied114414303bandied
bandies104124863bandies
bandsman1346753bandsman
barmen105418533ba_rmen
basemen1139083basemen
batmen104414303ba_tmen
batsmen1146883batsmen
baymen134212003ba_ymen
beadmen12299453beadmen
birdmen1235833birdmen
boardmen1344073boardmen
bondman1238043bondman
bondsmen1345473bondsmen
cabmen123610653ca_bmen
candent10417363cand_ent
candied113816023candied
candies104125613candies
candle94321483candle_
candled113815733candled
candler103516593candler
candles104422343candles
canteen9411083canteen
carmen104019343ca_rmen
cavemen1437143cavemen
clansmen1245723clansmen
condemn1237113condemn
daimen92210573da_imen
dander811222993dand_er
dandier93714573dandier
dandies94121443dandies
dandle84218093dandle_
dandled103313543dandled
dandler94414273dandler
dandles94218533dandles
daysmen1335083daysmen
deadmen11248573deadmen
gagmen103910413ga_gmen
gander84322763gand_er
garden84215083gard_en
gasmen93111563ga_smen
gatemen1047603gatemen
goodmen1135623goodmen
gunmen9348723gun_men
hackmen1836713hackmen
handed114919983hand_ed
hander104526433hand_er
handgun1244623handgun
handier113817443handier
handle104219293handle_
handled124114533handled
handler113516163handler
handles114020653handles
handsel11308723handsel
handset113016823handset
handsewn1543623handsewn
handyman1745223handyman
hangman1337793hangman
hanuman1237123hanuman
harden105718533hard_en
headmen13259513headmen
herdmen13238453herdmen
husbandmen1851213husbandmen
jazzmen2442503jazzmen
junkmen2033633junkmen
kinsmen1335653kinsmen
laden65022193la_d_en
landed84619243land_ed
lander74028483land_er
landler84113203landler
landsman1156853landsman
lawmen11308593la_wmen
laymen113010843la_ymen
leadmen10277903leadmen
lensmen937883lensmen
linden7411453lind_en
linemen938633linemen
linkmen1335363linkmen
madden103912523ma_dden
madman113712383ma_dman
maiden93512283maid_en
mailmen1137273mailmen
mandrel1038683mandrel
nandin7313033nand_in
nankeen1135043nankeen
nomen75621623__nomen
nonmen8412833non_men
numen74216793__numen
oarsmen938093oarsmen
packmen1746313packmen
pander93725523pand_er
pandied113913443pandied
pandies104224503pandies
pangen94115913pan_gen
penmen10311493pen_men
ragmen93712183ra_gmen
ramen75625193ra__men
ranchmen1545833ranchmen
randan7315253rand_an
randier83618473randier
randies84225663randies
reedmen1038333reedmen
rodmen939713_rodmen
saddens9309603sa_ddens
sadder82916973sa_dder
saddle83915493saddle_
saddled103112033saddled
saddler93811963saddler
saddles95415743saddles
sade55544473sa_d_e_
sades65239893sa_d_es
sadhe94815133sa_dhe_
sadhes104715373sa_dhes
sagaman10117553sagaman
saimin8313663sa_imin
salesmen1047243salesmen
salmon84614183sa_lmon
same65245643sa__me_
samek114915273sa__mek
samisen937673samisen
sand55338463sand___
sandal73317283sand_al
sandaled1039233sandaled
sandals82715203sandals
sandbag11106243sandbag
sandbank1544863sandbank
sandbar10108193sandbar
sandbox1744803sandbox
sandbur10105353sandbur
sanddab1144923sanddab
sanders84025943sanders
sandfly1435643sandfly
sandhi1038193sand_hi
sandhis1139993sandhis
sandhog1275453sandhog
sandiest93218683sandiest
sanding93520603sanding
sandless93212343sandless
sandling102214413sandling
sandlot8311693sandlot
sandpeep1342963sandpeep
sandpit1049633sandpit
sands65228583sand__s
sandy94221133sand__y
sane45954333san__e_
saned65636273san__ed
saner54334323san__er
sanes55649073san__es
sanger74524563san_ger
sanidine939853sanidine
sanies63031953san_ies
sansei63411903san_sei
sardine83317393sardine
sarment9318763sa_rment
sarsen6314233sa_rsen
sateen63815013sa_teen
scandent1148493scand_ent
seamen84518563s_eamen
seedman1037373seedman
seedsmen1144303seedsmen
semen75724103s__emen
sended85121233send_ed
sender73824413send_er
shandies122714103shandies
shantymen1762503shantymen
shipmen14317283shipmen
shodden12265753shodden
shopmen14277193shopmen
showmen15227163showmen
sidemen1037943sidemen
skymen1535313s_kymen
slander84015443sland_er
slidden935153slidden
smidgen11426513smidgen
snowmen12246153snowmen
sockmen1535453sockmen
socmen1039193s_ocmen
sodden84011513s_odden
sokemen1337053sokemen
sonarmen1045253sonarmen
sonde64622833sond_e_
sonder73623523sond_er
sondes74922873sond_es
soundman1144713soundman
spacemen1445413spacemen
spaldeen1142773spaldeen
spandex1735833spand_ex
spandrel1144063spandrel
stamen84115943s_tamen
standee83514513stand_ee
standees93310143standees
stander84316163stand_er
stuntmen1053703stuntmen
sudden83310833s_udden
sundae7312873sundae_
sundaes8313093sundaes
sunder74019823sund_er
sundew10369693sund_ew
sundown1186313sundown
sunken103511783sun_ken
surfmen1235993surfmen
swagmen1334973swagmen
swidden1234233swidden
swingmen1443483swingmen
swordmen1443003swordmen
syndet10311963synd_et
tandem9311403tand_em
tandems1037633tandems
taximen1644923taximen
taxmen15367443ta_xmen
tinmen82310393tin_men
tongmen1037113tongmen
vanman1139793van_man
wadmel1235523wa_dmel
wander104423713wand_er
wandle105316663wandle_
warden104515513ward_en
wingmen1336103wingmen
woodmen1356053woodmen
yamen104115183ya__men
yardman1335913yardman
zander163417113zand_er

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.1401276364.3
2DLD Change Limit1340272597.48617903.7
3Display Results2592590.0932784.9
 (SQL Overall)1786912597.71923149.5
 
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.