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

121 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
woodman133631(None) 
goodman1135931goodman
woodmen1356051woodmen
woodsman1444791woodsman
woolman1235431woolman
bondman1238042bondman
bookman15136482bookman
doorman1037062doorman
footman1236402footman
goodmen1135622goodmen
rodman949712_rodman
swordman1443402swordman
woman105818002w_o_man
woodbin1354872woodbin
wooden103610302wood_en
woodhen1454722woodhen
woodland1344602woodland
woodsmen1444632woodsmen
woodwax2143472woodwax
woolmen1234972woolmen
workman1635612workman
adman84517903__adman
aidman92410623_aidman
badman113813843_badman
beadman12249153beadman
birdman1236673birdman
boardman1344393boardman
boatman1147053boatman
bogyman1544933bogyman
bondmen1237893bondmen
bondsman1345693bondsman
boogyman1643093boogyman
bookmen15126263bookmen
bowman13129853_bowman
colorman1247893colorman
cooncan1147233cooncan
cowman13910373_cowman
deadman11238423deadman
dolman95312403_dolman
doodad936423dood_ad
doormat1059073doormat
doormen1036753doormen
foeman11311233_foeman
footmen1246583footmen
foreman12312363foreman
frogman1335873frogman
goddamn1242673goddamn
headman13229633headman
herdman13238423herdman
ironman936613ironman
jordan1468063jord_an
landman1038923landman
leadman10237843leadman
madman113712383_madman
motorman1246143motorman
nonman8412363_nonman
oilman839483_oilman
outman83115033_outman
plowman1444933plowman
postman112410043postman
potman102813573_potman
propman1339063propman
reedman1037723reedman
rodmen939713_rodmen
rodsman1036653rodsman
roman75424823_ro_man
sandman10310173sandman
seedman1037373seedman
shopman14247253shopman
showman15257283showman
snowman12226623snowman
sockman1535663sockman
socman1039813_socman
sokeman1337263sokeman
soldan73511853sold_an
soman75024903_so_man
soudan73210353soud_an
soundman1144713soundman
swordmen1443003swordmen
swordsman1542773swordsman
tollman935863tollman
toman75724053_to_man
tongman1037553tongman
wadmal1237283w_admal
wingman1336363wingman
wireman1237843wireman
woadwax2142163woadwax
womans114613653w_o_mans
women104619253w_o_men
womyn13426363w_o_myn
wood85329383wood___
woodbind1543713woodbind
woodbine1444973woodbine
woodbins1445043woodbins
woodbox2043693woodbox
woodchat1743563woodchat
woodcut1344683woodcut
wooded114213683wood_ed
woodgrain14312783woodgrain
woodhens1534103woodhens
woodie103513613wood_ie
woodier113912063woodier
woodies113517153woodies
wooding123012023wooding
woodlands1444153woodlands
woodlark1693303woodlark
woodlot1147023woodlot
woods95723033wood__s
woodsia1144173woodsia
woodsias1244923woodsias
woodsy13505923wood_sy
woodtone1245153woodtone
woodwaxen2351953woodwaxen
woodwind1643753woodwind
woody125116883wood__y
woolen93111373woo_len
woolhat1346043woolhat
woollen1034723woollen
workmen1635933workmen
yardman1335913yardman
yeoman1138823yeo_man

Search took 7 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 Limit1340271216.47020715.1
3Display Results1211210.0462630.4
 (SQL Overall)1786911216.66926794.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.