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

169 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
postman11241004(None) 
postmen113110421postmen
potman102813571po_tman
boatman1147052boatman
dustman1044682dustman
footman1236402footman
outman83115032_outman
pitman102412122p_itman
pointman1244802pointman
postal84317532post_al
postbag1245222postbag
posteen93512622posteen
postern93615612postern
postin83521032post_in
postmark1645432postmark
posttax1645532posttax
postwar1236902postwar
potmen102713092po_tmen
ashman1148383_ashman
atman75520143__atman
baseman1138553baseman
batman105214063_batman
batsman1157993batsman
boatmen1146913boatmen
boatsman1245703boatsman
bogyman1544933bogyman
bondman1238043bondman
bookman15136483bookman
boston8513043bost_on
bowman13129853bo_wman
bushman1455693bushman
busman10310253bus_man
costa75523733cost_a_
costae85319683cost_ae
costal85419513cost_al
costar85518613cost_ar
costmary1545053costmary
cotan71521783co_t_an
cowman13910373co_wman
deskman1444323deskman
desman9311693des_man
dolman95312403do_lman
doorman1037063doorman
dustmen1035773dustmen
dustpan1043243dustpan
foeman11311233fo_eman
footmen1246583footmen
foreman12312363foreman
frontman1344303frontman
fustian1036903fustian
gasman92911743gas_man
goodman1135933goodman
gossan747233gos_san
hetman112510603_hetman
hitman112710223_hitman
horseman1346823horseman
hosta85917833host_a_
hostas94515823host_as
houseman1346573houseman
liftman1244063liftman
meatman1137903meatman
messman1137283messman
mortmain1244573mortmain
nonman8412363no_nman
octan71313483_oct_an
oilman839483_oilman
osteal6312963_osteal
ostia52315583_ostia_
ostmark1344873_ostmark
ottoman946283_ottoman
outmans92413283_outmans
outran63218893_outran
packman1736693packman
partan83820563part_an
pasta76624533past_a_
pastas85422873past_as
pastern94415063pastern
pastina93914593pastina
penman10312323p_enman
pikeman1535523pikeman
piston83515923pist_on
pitmans11188743p_itmans
pitmen102510793p_itmen
pivotman1542053pivotman
platan83913693plat_an
plowman1444933plowman
pointmen1245423pointmen
ponton83217643pont_on
pontoon93010703pontoon
portal84218463port_al
portion9615493portion
portray1237483portray
posada937163posada_
posadas1037193posadas
position10912193position
positron1096903positron
post67953363post___
postage103214853postage
postals93716373postals
postanal1048053postanal
postbags1345293postbags
postbase1246443postbase
postbox1885493postbox
postboy1476673postboy
postburn1243923postburn
postcard1346523postcard
postcava15134033postcava
postdate1139653postdate
postdoc1245263postdoc
posted93722493post_ed
posteens10309733posteens
poster84129173post_er
posterns102713723posterns
posters93928013posters
postface1566123postface
postfix1944683postfix
postgame1345523postgame
postgrad1245493postgrad
postheat13411243postheat
postie84123963post_ie
posties93128813posties
posting105622243posting
postins93721203postins
postmarks1744753postmarks
postmating1548603postmating
postop10511943post_op
postops11311713postops
postoral10311723postoral
postpaid1376543postpaid
postpone1248693postpone
postpunk1642303postpunk
postrace12310533postrace
posts75228783post__s
postsync1542143postsync
postteen1055693postteen
postulant1147313postulant
postural1049203postural
posture9313253posture
poteen83514263po_teen
potion84519573po_tion
potteen9319673potteen
preman104117453p_reman
pressman1247153pressman
propman1339063propman
prosimian1366003prosimian
prosoma11310223prosoma_
prosomal1248543prosomal
prosomas1249723prosomas
protean92412193protean
pullman1135403pullman
rodman949713ro_dman
rodsman1036653rodsman
roman75424823ro__man
rostra6310933rostra_
rostral7311333rostral
routeman10135493routeman
sockman1535663sockman
socman1039813so_cman
sokeman1337263sokeman
soman75024903__soman
sportsman1343873sportsman
titman82711003_titman
tollman935863tollman
toman75724053to__man
tongman1037573tongman
woman105818003wo__man
woodman1336313woodman
woolman1235433woolman
workman1635613workman

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 Limit1340271696.58020368.8
3Display Results1691690.0602816.7
 (SQL Overall)1786911697.04625360.6
 
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.