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

249 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
swindle1138918(None) 
dwindle12415881dwindle
spindle103210091spindle
swindled13307621swindled
swindler12257721swindler
swindles12319501swindles
swingle113510561swingle
windle104617951_windle
bindle94516262_bindle
brindle104210102brindle
dindle84417222_dindle
dwindled14385022dwindled
dwindles13366022dwindles
kindle114414232_kindle
shingle117711282shingle
sidle65124032s_i_dle
single74520602s_ingle
spindled12287642spindled
spindler11297982spindler
spindles112710352spindles
spindly13257382spindly
spinule9299992spinule
swaddle12276742swaddle
swindlers13306032swindlers
swine85625302swin__e
swinge105614382swin_ge
swingled13337432swingled
swingles12319542swingles
swiple11379232swi_ple
swipple1444632swipple
swizzle1854102swizzle
trindle83311362trindle
twiddle12305482twiddle
twinkle1464772twinkle
wandle105316662_wandle
widdle113814842_widdle
windled123713482_windled
windles113518492_windles
winkle133812832_winkle
wintle94014602_wintle
atingle848253atingle
bindles104016453_bindles
blindly1335743blindly
bridle94115463bri_dle
brindled12407853brindled
brindles113710223brindles
bundle94315573_bundle
candle94321483_candle
cringle103010353cringle
crinkle13359413crinkle
dandle84218093_dandle
diddle94915213_diddle
dindled104412723_dindled
dindles93817243_dindles
dingle84317073_dingle
dwine95616143dwin__e
enkindle1363163enkindle
fiddle113613383_fiddle
finale94116763_finale
fondle104412943_fondle
girdle82110463_girdle
griddle1035503griddle
gwine95513663gwin__e
handle104219293_handle
hondle103914523_hondle
idle55423763__i_dle
indie63721473__indie
indole74516053__indole
indue63516673__indue
ingle64120433__ingle
inkle94515833__inkle
jingle143815223_jingle
kindled133410543_kindled
kindler12309983_kindler
kindles123614843_kindles
kindly14358843_kindly
middle103414983_middle
mingle93518783_mingle
piddle103514913_piddle
pinole83218783_pinole
pintle83818263_pintle
rekindle1344643rekindle
riddle83915713_riddle
rundle73214233_rundle
saddle83915493s_addle
saintly1039343saintly
sanicle91210263sanicle
seidel7311083sei_del
seine55732873sein__e
senile63420213s_enile
shindies122610503shindies
shindig12244243shindig
shindy13449323shind_y
shindys14314133shindys
shine85533093shin__e
shingled13358323shingled
shingler12268633shingler
shingles123111113shingles
shingly143210813shingly
shinily13268933shinily
sickle124418323s_ickle
side55444493s_i_d_e
sidhe95315103s_i_dhe
sidled84215173s_i_dled
sidler74716963s_i_dler
sidles74721153s_i_dles
simile83115633s_imile
simple104315173s_imple
since75024173s_in_ce
sine46560623s_in__e
singe65731133s_in_ge
singled93914683s_ingled
singles83520433s_ingles
singlet84120113s_inglet
singly104015853s_ingly
sizzle14309613s_izzle
skiable1338883skiable
skiffle17225203skiffle
skittle1135533skittle
slide64725413sli_d_e
smidge10378483smi_dge
smile74823923smi__le
snide64318723sni_d_e
sniffle13287653sniffle
sniggle9316833sniggle
sonde64622833s_ond_e
soundly1136683soundly
spangle1038403spangle
spicule11269933spicule
spile75230083spi__le
spinage10289653spinage
spinal84915313spinal_
spinals93911863spinals
spinate93114813spinate
spindlers12286453spindlers
spindlier1253873spindlier
spine76534423spin__e
spinel85317333spinel_
spinelle1046223spinelle
spinels94512443spinels
spinose937943spinose
spinula9257903spinula
spinulae10276963spinulae
spinules10249333spinules
spittle937923spittle
spondee10310593spondee
sprinkle1434893sprinkle
staddle9288093staddle
standee83514513standee
stickle132410973stickle
stifle93611903sti_fle
stile54931573sti__le
stipple1146623stipple
stipule936723stipule
sundae7312873s_undae
swaddled14254963swaddled
swaddles13296453swaddles
swale85221593sw__ale
swede94413203sw_ed_e
swidden1234233swidden
swiftlet1444793swiftlet
swiftly1633733swiftly
swill83417373swi__ll
swilled113611833swi_lled
swiller103211663swi_ller
swills94213363swi_lls
swindling14135833swindling
swing96124843swin__g
swingby16343893swingby
swinged123810793swinged
swinger113812563swinger
swinges113413423swinges
swingier12267003swingier
swingmen1443493swingmen
swings104714453swin_gs
swingy13489873swin_gy
swinish1347203swinish
swink125116353swin__k
swinked15349033swinked
swinks134610653swin_ks
swinney13365973swinney
swipe105217083swi__pe
swiples12339643swi_ples
swipples1534843swipples
swirl84514143swi_rl_
swirled11308223swi_rled
swirls94010133swi_rls
swirly12439253swi_rly
swithe124010683swi_the
swithly1634443swithly
swive115316193swi__ve
swivel12369323swivel_
swiveled1544163swiveled
swivels13396773swivels
swizzled2053013swizzled
swizzler1963223swizzler
swizzles1953783swizzles
tingle74319063_tingle
tinkle103714453_tinkle
trindled10388693trindled
trindles93211683trindles
trundle8307873trundle
twaddle12245713twaddle
twangle1145803twangle
tweedle1134193tweedle
twiddled14284633twiddled
twiddler13244873twiddler
twiddles13265613twiddles
twiddly15233773twiddly
twine85822363twin__e
twinge104210403twin_ge
twinkie1434573twinkie
twinkled1663943twinkled
twinkler1564073twinkler
twinkles1535073twinkles
twinkly1733913twinkly
veinule1056243veinule
waddle114715303_waddle
wangle103817503_wangle
widdie113410733_widdie
widdled133511233_widdled
widdles123514343_widdles
wide85235413_wi_d_e
wiggle113713013_wiggle
wildly13328123_wildly
wile75944373_wi__le
wimble133211923_wimble
wimple133611363_wimple
wince105220883_win_ce
wind85533853_wind__
windable14159153_windable
windage1237933_windage
winded114918213_winded
winder104025263_winder
windier113412163_windier
windily1437943_windily
windless123310863_windless
window1347363_window
winds95425603_wind_s
windup1235383_windup
windy126118103_wind_y
wine74953423_win__e
winglet113115983_winglet
winkled15299593_winkled
winkles143412773_winkles
wintled11339843_wintled
wintles103414983_wintles
winze175014853_win_ze
wrinkle14296923wrinkle

Search took 9 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.623286823.4
2DLD Change Limit1340272497.51617832.2
3Display Results2492490.0932677.4
 (SQL Overall)1786912498.23221706.9
 
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.