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 “waughted” 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
waughted164348(None) 
wauchted1753371wauchted
claughted1643242claughted
daughter1344502daughter
draughted1543692draughted
fraughted1743602fraughted
laughed1235892laugh_ed
laughter1245112laughter
oughted1236222_oughted
waught133811042waught__
waughts14355962waught_s
weighted1635592weighted
alighted1347673alighted
audited939033_audited
aught95120703_aught__
aughts104710243_aught_s
augite7312613_augite_
augites8312183_augites
augured987193_augured
aurated83817793_aurated
bighted142810923_bighted
blighted1546863blighted
boughed143810263bough_ed
boughten1444193boughten
caudated1238063caudated
caught124911683caught__
coughed143310903cough_ed
daughters1443993daughters
daunted93810193dau_nted
dauted84114933dau__ted
dighted132511493_dighted
faggoted1443103faggoted
fagoted1236073fa_goted
faulted11227723fau_lted
flighted1646973flighted
foughten1544003foughten
frighted1657173frighted
gauged94713473gaug__ed
haughtier1642743haughtier
haughty17334643haught_y
haunted11399733hau_nted
highted152710163_highted
jaunted15418563jau_nted
knighted1745123knighted
laugher1136603laugh_er
laughters1344593laughters
lighted122913503_lighted
naught104312493naught__
naughtier1343103naughtier
naughties1344573naughties
naughts11447513naught_s
naughty14445623naught_y
pargeted1238683pargeted
paughty16294323paught_y
plighted1546463plighted
righted122912143_righted
roughed124210943rough_ed
sauted74119603sau__ted
sighted123111523_sighted
slaughter1344003slaughter
slighted1357393slighted
soughed123811623sough_ed
sughed113610203_sugh_ed
targeted1037483targeted
taught104312243taught__
taunted84310963tau_nted
tauted75317113tau__ted
toughed123511693tough_ed
vaulted11307193vau_lted
vaunted11438863vau_nted
wafted134012143wa__fted
waged104822783wa_g__ed
wagered12299333wa_gered
wagged124616123wa_g_ged
waggled13389363wa_ggled
waggoned1443253waggoned
wagoned1256223wa_goned
waisted114210943wa_isted
waited103819773wa__ited
wangled123312413wang_led
wanted104319723wa__nted
warted104223233wa__rted
washed135521503wa_sh_ed
wasted104423023wa__sted
watched163012823watch_ed
waucht14399413waucht__
wauchts15285283waucht_s
waugh125411683waugh___
waughting1743123waughting
wauked144210573wau__ked
wauled104713963wau__led
weighed15135933weigh_ed
weighter1535603weighter
whishted1843153whishted
yachted1634853ya_chted

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 Filter1786911461620.406440125.6
2DLD Change Limit146162957.00020880.3
3Display Results95950.0462065.2
 (SQL Overall)178691957.45223978.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.