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

95 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
deskman144432(None) 
deskmen1435021deskmen
desman9311691des_man
deadman11238422deadman
decuman1236572decuman
desmans1039002des_mans
dustman1044682dustman
messman1137282messman
ashman1148383_ashman
baseman1138553baseman
beadman12249153beadman
bedeman12168843bedeman
bedesman1345083bedes_man
bellman1137183bellman
bookman15136483bookman
bushman1455693bushman
busman10310253bus_man
chessman1544823chessman
dalesman1145803dales_man
daman84821163d__aman
daysman1335053daysman
deadmen11248573deadmen
deadpan11225233deadpan
dean56039483de___an
decimal1238083decimal
deckhand1943103deckhand
deewan10267553de_ewan
demand104314253de__mand
demean9510563de_mean
demon86520313de__mon
derma84918513de_rma_
dermal93614343de_rmal
dermas94116813de_rmas
desand84812633des__and
descant104315583des_cant
design8408933des_ign
desk95618903desk___
desks105913073desk__s
desktop1442413desktop
desmid1048363des_mid
destain8412083destain
desugar944033desugar
dewan95718043de__wan
dextran1586163dextran
dishpan13105523dishpan
dismal92412243dis_mal
dismay12229473dis_may
doeskin1245153doesk_in
dolman95312403d_olman
doorman1037063doorman
drayman1335433drayman
dustmen1035773dustmen
dustpan1043243dustpan
eskar9457453_esk_ar
freshman1644623freshman
gasman92911743gas_man
german9611983ge_rman
hackman1836433hackman
headman13229633headman
herdman13238423herdman
hessian1035853hessian
hetman112510603he_tman
junkman2043173junkman
kirkman1243773kirkman
leadman10237843leadman
legman949653le_gman
leman75622603le__man
lensman937563lensman
lesbian944463lesbian
linkman1335383linkman
meatman1137903meatman
merman10513853me_rman
mesian84315503mes_ian
messan83912063mes_san
messmen1137393messmen
milkman1544913milkman
newsman1245503newsman
packman1736693packman
pekan111613973pe_k_an
penman10312323pe_nman
postman112410043postman
pressman1247153pressman
reedman1037723reedman
reman75730153re__man
seaman84015903se_aman
seedman1037373seedman
skean94415623__skean
skyman1535313__skyman
sockman1535663sockman
soman75024903__soman
teleman959573teleman
verseman1345383verseman
workman1635613workman
yeggman1442923yeggman
yeoman1138823ye_oman

Search took 9 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.1561145455.1
2DLD Change Limit134027958.37316007.0
3Display Results95950.0631507.9
 (SQL Overall)178691958.59220797.4
 
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.