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

106 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
whiffle193353(None) 
whiffled2133041whiffled
whiffler2033481whiffler
whiffles2034261whiffles
piffle14418232_piffle
riffle124210232_riffle
shuffle16276922shuffle
skiffle17225202skiffle
sniffle13287652sniffle
waffle15369182w_affle
whiff17310062whiff__
whiffed2064472whiffed
whiffer19105322whiffer
whiffet1965342whiffet
whifflers2142772whifflers
whiffs1835082whiff_s
while115418692whi__le
whistle13107532whistle
whittle13106102whittle
awhile1257793awhi__le
baffle14399873_baffle
chicle134312543chi_cle
chiefly1834103chiefly
chiffon1844053chiffon
chile105626893chi__le
coffle14359043_coffle
coiffe1447043coiff_e
duffle13368533_duffle
griffe13438093griff_e
higgle113811743_higgle
hirple11158973_hirple
hirsle9159573_hirsle
muffle14339643_muffle
piffled16366403_piffled
piffles15368763_piffles
raffle123910703_raffle
riffled14338603_riffled
riffler13328353_riffler
riffles133911163_riffles
rifle85518333_ri_fle
ruffle124111673_ruffle
scuffle15266893scuffle
shingle117711283shingle
shuffled18296243shuffled
shuffler17306803shuffler
shuffles17297783shuffles
skiffled19244423skiffled
skiffles18265713skiffles
snaffle13216253snaffle
sniffled15276443sniffled
sniffler14296833sniffler
sniffles14257723sniffles
sniffly16265643sniffly
snuffle13267833snuffle
souffle13306803souffle
stiffie13245773stiffie
stiffly16235173stiffly
stifle93611903sti_fle
thimble1435873thimble
thistle10107803thistle
trifle94012883tri_fle
truffle1384893truffle
waffie15338563w_affie
waffled17357523w_affled
waffler16377783w_affler
waffles16329983w_affles
waffly18305433w_affly
whale115517433wh__ale
wheedle1434823wheedle
wheeple1534853wheeple
whiffers2064493whiffers
whiffets2072523whiffets
whiffing2134703whiffing
whiffling2242883whiffling
whiled134514133whi__led
whiles124418013whi__les
whine116022813whi__ne
whinge134311543whi_nge
whirl114913823whi_rl_
whirled14368043whi_rled
whirler13307603whi_rler
whirls124710533whi_rls
whirly15448863whi_rly
whistled1595783whistled
whistler1496313whistler
whistles14108213whistles
white114920303whi__te
whitefly2042513whitefly
whitely16346473whitely
whittled1594913whittled
whittler1495193whittler
whittles1496673whittles
whole114418093wh__ole
whortle13335943whortle
widdle113814843w_iddle
wife105228023w_i_f_e
wifely15429423w_ifely
wiggle113713013w_iggle
wile75944373w_i__le
wimble133211923w_imble
wimple133611363w_imple
windle104617953w_indle
winkle133812833w_inkle
wintle94014603w_intle
wriggle12316213wriggle
wrinkle14296923wrinkle

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.423422437.4
2DLD Change Limit1340271065.65623696.4
3Display Results1061060.0303533.3
 (SQL Overall)1786911066.10929250.5
 
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.