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

49 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
doughtier144346(None) 
doughier1335481dough_ier
droughtier1542611droughtier
daughter1344502daught_er
doughtiest1543232doughtiest
doughtily1742372doughtily
draughtier1542442draughtier
haughtier1642742haughtier
naughtier1343102naughtier
boughten1444193bought_en
cougher133711733cough__er
courtier1059333cou_rtier
couthier13218913couth_ier
daughters1443993daught_ers
dodgier10388243dodg__ier
doggier103810943do_g_gier
dotier73917033do___tier
dottier83910923do__ttier
doubter10298353dou_bt_er
doughiest1435783dough_iest
doughlike1842683doughlike
dought114915523dought___
doughtiness1642703doughtiness
doughty15436023dought__y
droughtiest1652343droughtiest
drouthier1343033drouth_ier
druggier11134833drug_gier
dustier83814133d_u_stier
flightier1644423flightier
foughten1544003fought_en
goutier82612353gou__tier
laughter1245113laught_er
mightier1436383_mightier
mouthier13208173mouth_ier
naughties1344573naughties
oughted1236223_ought_ed
oughting1335953_oughting
pouchier1546803pouch_ier
poutier93215323pou__tier
rougher113511033rough__er
roughies1298323rough_ies
roughrider1551843roughrider
sloughier1343673slough_ier
touchier1347383touch_ier
toughener1344163toughener
tougher114210983tough__er
toughie1187593tough_ie_
toughies1278243tough_ies
weightier1643313weightier

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 Filter1786911486410.420425454.8
2DLD Change Limit148641496.89321564.1
3Display Results49490.0163062.5
 (SQL Overall)178691497.32924381.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.