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

131 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
wafture133485(None) 
waftures1434851waftures
capture1138912capture
facture12108932facture
mature8313472ma_ture
nature6311262na_ture
pasture9311462pasture
rapture937392rapture
waftage14115322waftage
wafter124114612wafter_
wafters134112812wafters
abjure1536743_abjure
adjure1435843_adjure
afire86215913_af_ire
afore85818603_af_ore
after85719793_after_
afters94717073_afters
allure63012943_allure
antre55224523_ant_re
armure8710133_armure
assure6610773_assure
astute6310763_astute
attire62412383_attire
attune637983_attune
azure14911483_a_zure
battue84311003battu_e
captured1336573captured
capturer1246093capturer
captures1239443captures
cloture9238453cloture
couture9310623couture
culture939393culture
dafter104813343dafter_
dasyure1153823dasyure
datura738033da_tura
denture8311893denture
factures13129033factures
failure1035753failure
feature1039853feature
fixture1734963fixture
fracture13147143fracture
future939563_future
gesture839243gesture
hachure1545723hachure
haftara13136093haftara
hafter124815883hafter_
hafters134614333hafters
haltere103614713haltere
lecture9149523lecture
maftir1136493maftir_
maftirs1236043maftirs
manure8313653ma_nure
matured10310043ma_tured
maturer938983ma_turer
matures9314313ma_tures
mixture1635413mixture
multure939183multure
natured838963na_tured
natures7311963na_tures
nurture736643nurture
parure8312523pa_rure
pastured1138233pastured
pasturer1037523pasturer
pastures10311963pastures
picture1158613picture
posture9313253posture
rafter94517583rafter_
raftered1237663raftered
rafters103715633rafters
raptured1155473raptured
raptures1037583raptures
rasure6311423ra_sure
rupture966163rupture
saltire73113043saltire
santur6311273santur_
santurs7310763santurs
satire63218003sa_tire
stature74410683stature
suture6313203_suture
tartare73012683tartare
tartufe1064673tartufe
texture1497083texture
torture738593torture
venture10311173venture
vesture10310373vesture
vulture1036763vulture
wafer114417643waf_er_
wafered14288433waf_ered
wafers124316143waf_ers
wafery15398693waf_ery
waffie15338563waf_fie
waffle15369183waf_fle
waffler16377783waffler
waft106139003waft___
waftages15105393waftages
wafted134012143waft_ed
wafting143911663wafting
wafts116920553waft__s
waiter94321253waiter_
waitered1238753waitered
waiters104218623waiters
waltzer1934383waltzer
wantage11119623wantage
wanter94423053wanter_
wanters104420093wanters
ware76254723wa___re
warfare1336733warfare
wartier103413913wartier
wartime1237743wartime
wastage11109253wastage
waste86125053wast__e
waster95228943waster_
wasterie111211583wasterie
wasters104026593wasters
wastery134610993wastery
wastrel1037553wast_rel
wastrie101210303wastrie
wastry12388773wast_ry
watape11208483wa_tape
water84733313wa_ter_
watered113014953wa_tered
waterer103314073wa_terer
waters95030633wa_ters
watery123914493wa_tery
wattage1186983wattage
wattape12135383wattape
watter93221983watter_
wattle94314213wa_ttle
waur76819903wa__ur_
wiftier13297733wiftier
zaffre21354663zaf_fre

Search took 7 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.420425454.8
2DLD Change Limit1340271316.09321996.9
3Display Results1311310.0502620.0
 (SQL Overall)1786911316.56327227.0
 
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.