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

73 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
waughting174312(None) 
wauchting1843471wauchting
claughting1742482claughting
draughting1642882draughting
fraughting1843062fraughting
laughing1335932laugh_ing
oughting1335952_oughting
weighting1744782weighting
alighting1446413alighting
auditing1039033_auditing
auguring1036383_auguring
bighting15269453_bighting
blighting1635733blighting
coughing15309213cough_ing
daunting103310403dau_nting
dauting93814763dau__ting
dighting142510843_dighting
faggoting1543313faggoting
fagoting1336283fa_goting
faulting12237733fau_lting
fighting162710083_fighting
flighting1736103flighting
frighting1736023frighting
gauging10339963gaug__ing
haughtier1642743haughtier
haughtily1941993haughtily
haunting123510053hau_nting
highting16259723_highting
jaunting16328633jau_nting
knighting1844443knighting
laughings1443483laugh_ings
laughline1342913laughline
lighting132811833_lighting
naughtier1343103naughtier
naughties1344573naughties
naughtily1642283naughtily
pargeting1338283pargeting
plighting1635563plighting
righting132610853_righting
roughing13278343rough_ing
sighting133110863_sighting
slighting1436373slighting
soughing13259733sough_ing
sughing12359713_sugh_ing
targeting1137303targeting
taunting93510933tau_nting
tauting83316383tau__ting
toughing13278553tough_ing
vaulting12227233vau_lting
vaunting12338753vau_nting
wafting143911663wa__fting
wagering13219523wa_gering
wagging133313353wa_g_ging
waggling14197063wa_ggling
waggoning1543593waggoning
waging114318383wa_g__ing
wagoning1336923wa_goning
waisting123615213wa_isting
waiting113618953wa__iting
wangling132310993wang_ling
wanting114220173wa__nting
washing145119283wa_sh_ing
wasting114422843wa__sting
watching173011173watch_ing
waught133811043waught___
waughted1643483waught_ed
waughts14355963waught__s
wauking153410013wau__king
wauling112713113wau__ling
waygoing1633273wayg_oing
weighing1635283weigh_ing
whishting1983563whishting
yachting1734933ya_chting

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.436409841.7
2DLD Change Limit148641736.53022762.8
3Display Results73730.0332212.1
 (SQL Overall)178691736.99925530.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.