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

133 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
workman163561(None) 
workmen1635931workmen
bookman15136482bookman
foreman12312362foreman
kirkman1243772kirkman
sockman1535662sockman
swordman1443402swordman
wireman1237842wireman
woman105818002wo__man
woodman1336312woodman
woolman1235432woolman
workbag1742922workbag
workday1843302workday
workmanly2151992workmanly
workmate1744672workmate
workwoman2143102workwoman
airman82414223air_man
barman103519703bar_man
birdman1236673birdman
boardman1344393boardman
boatman1147053boatman
bogyman1544933bogyman
bondman1238043bondman
bookmen15126263bookmen
bowman13129853bo_wman
carman103920743car_man
choreman15117603choreman
corban10314693cor_ban
corpsman1445133corpsman
cowman13910373co_wman
deskman1444323deskman
dolman95312403do_lman
doorman1037063doorman
dormant102814373dor_mant
dormin9312313dor_min
fireman1249333fireman
firman112211343fir_man
foeman11311233fo_eman
footman1236403footman
foramen12310533foramen
foremen12412923foremen
foreran10311793foreran
formal113215203for_mal
formant123416003for_mant
format113021353for_mat
frogman1335873frogman
german9611983ger_man
goodman1135933goodman
gormand1157453gor_mand
hackman1836433hackman
herdman13238423herdman
horseman1346823horseman
ironman936613ironman
jordan1468063jor_dan
junkman2043173junkman
juryman1943583juryman
kirkmen1232923kirkmen
korma115913073kor_ma_
kormas124511233kor_mas
linkman1335393linkman
loran55925093lor__an
marksman1645263marksman
merman10513863mer_man
milkman1544913milkman
morgan9311373mor_gan
mortmain1244573mortmain
nonman8412363no_nman
normal83213533nor_mal
oarsman937733oarsman
oilman839483_oilman
organ6915393_or_gan
origan7310693_origan
orphan1137733_orphan
outman83115033_outman
packman1736693packman
postman112410043postman
potman102813573po_tman
preman104117453_preman
propman1339063propman
reman75730153__reman
rodman949713ro_dman
rodsman1036653rodsman
roman75424823__roman
sockmen1535453sockmen
socman1039813so_cman
sokeman1337263sokeman
soman75024903so__man
stockman1644143stockman
surfman1236203surfman
swordmen1443003swordmen
swordsman1542773swordsman
tollman935863tollman
toman75724053to__man
tongman1037573tongman
turfman1243983turfman
wingman1336383wingman
wiremen1236903wiremen
woken124614973wo_k_en
womans114613653wo__mans
women104619253wo__men
womyn13426363wo__myn
woodmen1356053woodmen
woodsman1444793woodsman
woolmen1234973woolmen
work115528843work___
workaday1942273workaday
workbags1843013workbags
workboat1745463workboat
workbox2343313workbox
workdays1942903workdays
worked145314703work_ed
worker134715113work_er
workers144612693workers
workfare1843123workfare
working153813253working
workingman205753workingman
workload1643023workload
workmates1845003workmates
workout1448393workout
works125621903work__s
workup1534323work_up
workups1633613workups
workwomen2143793workwomen
worm96129493wor_m__
wormed124314303wor_med
wormer114514913wor_mer
wormil1138043wor_mil
worming132811243wor_ming
worms105320763wor_m_s
wormy137514253wor_m_y
worn75631753wor___n
worsen95513873wor_sen
yardman1335913yardman

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.406440125.6
2DLD Change Limit1340271337.40618097.1
3Display Results1331330.0462891.3
 (SQL Overall)1786911337.85822740.0
 
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.