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 “landsman” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

88 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
landsman115685(None) 
bandsman1346751bandsman
landman1038921land_man
landsmen1156601landsmen
bandsmen1356452bandsmen
bondsman1345692bondsman
clansman1245812clan_sman
handyman1745232handyman
landmen1038552land_men
langshan1244532langshan
leadsman1145242leadsman
lensman937562len_sman
linesman1046252linesman
linksman1444152linksman
plantsman1344672plantsman
sandman10310172sand_man
adman84517903_a_d_man
aidman92410623_aid_man
almsman1145093_almsman
antiman9313883_antiman
badman113813843ba_d_man
bailsman1245003bailsman
bandsaw1334803bands_aw
bandstand1343933bandstand
batsman1157993ba_tsman
beadsman1355613beadsman
bondman1238043bond_man
bondsmen1345473bondsmen
clansmen1245723clan_smen
dalesman1145803dalesman
daysman1335053da_ysman
gamesman1344513gamesman
gasman92911743ga__sman
glassman1145183gla_ssman
grantsman1265053grantsman
guardsman1342523guardsman
handsaw1435533hands_aw
handsewn1543623handsewn
handstand1444973handstand
handymen1744983handymen
hangman1337813han_gman
hanuman1237133han_uman
headsman1446353headsman
herdsman1465643herdsman
huntsman1343863huntsman
kinsman1335963kin_sman
landau7310613land__au
landgrab1243033landgrab
landmark1544153land_mark
landmass1144423land_mass
lands65426903lands___
landscape1443993landscape
landside10147443landside
landskip1583673landskip
landslid1085303landslid
landslip1184263landslip
langshans1344283langshans
laundryman1651383laundryman
lawman11289053la__wman
layman113511303la__yman
laywoman1643363laywoman
leadman10237843lead_man
leadsmen1154793leadsmen
lensmen937883len_smen
lineman939123lin_eman
linesmen1046563linesmen
linkman1335393lin_kman
linksmen1443523linksmen
madman113712383ma_d_man
marksman1645263marksman
oarsman937733oa_rsman
panhuman1544003panhuman
plainsman1343193plainsman
plantsmen1344143plantsmen
raftsman1344163raftsman
ranchman1546043ranchman
randan7315253rand__an
rodsman1036653_rodsman
roundsman1243423roundsman
salesman1047353salesman
sandmen1039413sand_men
sandsoap1143723sandsoap
seedsman1144893seedsman
talesman1046693talesman
talisman1045553talisman
vanman1139793van__man
woodsman1444793woodsman
yardman1335913yard_man

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 Filter1786911461620.453394461.4
2DLD Change Limit146162886.76321612.0
3Display Results88880.0332666.7
 (SQL Overall)178691887.24924650.4
 
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.