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

257 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
landmen103855(None) 
landman1038921landman
landsmen1156601landsmen
sandmen1039411sandmen
admen84516182_a_dmen
aidmen92610372_aidmen
badmen114613832ba_dmen
bandsmen1356452bandsmen
bondmen1237892bondmen
clansmen1245722clansmen
handymen1744982handymen
hangmen1337372hangmen
laden65022192la_d_en
landed84619242land_ed
lander74028482land_er
landler84113202landler
landsman1156852landsman
lawmen11308592la_wmen
laymen113010842la_ymen
leadmen10277902leadmen
lensmen937882lensmen
linden7411452lind_en
linemen938632linemen
linkmen1335362linkmen
madmen113511742ma_dmen
sandman10310172sandman
vanmen1138402van_men
yardmen1335422yardmen
abdomen1237023_abdomen
acumen1049013_acumen
adman84517903_a_dman
agnomen1036763agnomen
aidman92410623_aidman
airmen82612353_airmen
albumen1135243albumen
almsmen1144583almsmen
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
blander103715163bland_er
boardmen1344073boardmen
bondman1238043bondman
bondsmen1345473bondsmen
cabmen123610653ca_bmen
candent10417363cand_ent
candied113816023candied
candies104125613candies
candle94321483candle_
candled113815733candled
candler103516593candler
candles104422343candles
canteen9411083canteen
carmen104019343ca_rmen
cavemen1437143cavemen
clansman1245813clansman
condemn1237113condemn
daimen92210573da_imen
dander811222993dand_er
dandier93714573dandier
dandies94121443dandies
dandle84218093dandle_
dandled103313543dandled
dandler94414273dandler
dandles94218533dandles
daysmen1335083daysmen
deadmen11248573deadmen
flagmen13226913fla_gmen
flamen115215993fla__men
flanken14226763flan_ken
gagmen103910413ga_gmen
gander84322763gand_er
garden84215083gard_en
gasmen93111563ga_smen
gatemen1047603gatemen
gladden10376313gla_dden
glandes95413833gland_es
glassmen1145393glassmen
goodmen1135623goodmen
gunmen9348723gun_men
hackmen1836713hackmen
handed114919983hand_ed
hander104526433hand_er
handgun1244623handgun
handier113817443handier
handle104219293handle_
handled124114533handled
handler113516163handler
handles114020653handles
handsel11308723handsel
handset113016823handset
handsewn1543623handsewn
handyman1745223handyman
hangman1337793hangman
hanuman1237123hanuman
harden105718533hard_en
headmen13259513headmen
herdmen13238453herdmen
jazzmen2442503jazzmen
junkmen2033633junkmen
kinsmen1335653kinsmen
ladder84617623la_dder
laddie83713173laddie_
laddies93715053laddies
lade56345983la_d_e_
laded74232613la_d_ed
ladens74516233la_d_ens
lader65633723la_d_er
lades65141273la_d_es
ladies75124883la_dies
ladle66320443la_dle_
ladled85013483la_dled
ladler74314933la_dler
ladles74619543la_dles
ladron73413323la_dron
lame66849293la__me_
lamed85235293la__med
lament85024943la__ment
lamer75233703la__mer
lames75445543la__mes
lammed113915623la_mmed
lanate6421263lanate_
lanated8313203lanated
lance75126723lan_ce_
lanced93717723lan_ced
lancer84319973lan_cer
lances84824103lan_ces
lancet84223573lan_cet
land56337303land___
landau7310613land_au
landaus8310343landaus
landers84026213landers
landing92819323landing
landlers94312833landlers
landless94011173landless
landline9311443landline
landmark1544153landmark
landmass1144423landmass
lands65426903land__s
lane45153323lan__e_
lanes54946793lan__es
langley1147443langley
langrel8107033langrel
langue71012173langue_
langues81211913langues
languet8713693languet
lanker104123003lan_ker
lankier113711633lankier
lanner64920593lan_ner
lanolin7310643lanolin
lanose6313593lanose_
lantern7310013lantern
larchen12479623larchen
larded84319093lard_ed
larder73720973lard_er
lardier83518343lardier
lardon74415063lard_on
lardoon83410373lardoon
lateen64014863la_teen
laten54328343la__ten
latten65018203la_tten
lauded83812153laud_ed
lauder73815013laud_er
launder8309143laund_er
laundrymen1651413laundrymen
lawman11289053la_wman
layman113511303la_yman
laywomen1643703laywomen
leaden74515223lead_en
leadman10237843leadman
leadsmen1154793leadsmen
legmen939343l_egmen
lender73921273lend_er
lensman937563lensman
lenten6312883len_ten
liftmen1234233liftmen
limen75426033l__imen
lindane839023lindane
lindens839413lind_ens
lindies8416583lindies
lineman939113lineman
linen55728723lin__en
linesmen1046563linesmen
liniment1049533liniment
linkman1335383linkman
linksmen1443523linksmen
loden66621143l_od_en
louden73711793loud_en
lumen75220903l__umen
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
placemen1445783placemen
plainsmen1343463plainsmen
plantsmen1344143plantsmen
ragmen93712183ra_gmen
ramen75625193ra__men
ranchmen1545833ranchmen
randan7315253rand_an
randier83618473randier
randies84225663randies
reedmen1038333reedmen
rodmen939713_rodmen
sadden83212403sa_dden
sagamen10127503sagamen
sanded84920613sand_ed
sander74828533sand_er
sandier84017843sandier
seedmen1037683seedmen
slander84015443sland_er
soundmen1145233soundmen
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 Limit1340272577.69017428.7
3Display Results2572570.1062424.5
 (SQL Overall)1786912577.93622516.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.