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

226 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
whistles1410821(None) 
thistles1198231thistles
whistle13107531whistle_
whistled1595781whistled
whistler1496311whistler
whistlers1595161whistlers
whittles1496671whittles
bhisties1339002bhisties
bristles101510432bristles
epistles1047782epistles
gristles9189202gristles
hustles103414172_hustles
istles62814982__istles
thistle10107802thistle_
waistless1235092waistless
warstles11368802warstles
whiffles2034262whiffles
whiles124418012whi__les
whishes16309442whis_hes
whiskies1835952whiskies
whisted144010012whist_ed
whists124613812whist__s
whites123919882whi_t_es
whities133113252whi_ties
whittle13106102whittle_
whittled1594912whittled
whittler1495192whittler
whittlers1594332whittlers
whortles14306742whortles
wintles103414982w_intles
wrastles11328932wrastles
wrestles113310062wrestles
wristlet1138642wristlet
wristlets1244472wristlets
aisles64721143_ais_les
anisoles81010123anisoles
apostles1037753apostles
bhistie1236773bhistie_
bistres94017213_bistres
bristle91910103bristle_
bristled11187343bristled
brittles10178653brittles
bustles93816323_bustles
castles94917733_castles
chicles143512503chi_cles
chiles115425303chi__les
chintses1337113chintses
chintzes2235973chintzes
chipotles1643793chipotles
chiseled1435883chiseled
chiseler1335903chiseler
chiselers1445453chiselers
chisels12219103chisel_s
chitties13310773chitties
chortles133611323chortles
christies1449263christies
cuittles1045903cuittles
enisles72312603enis_les
epistle957893epistle_
epistler1044833epistler
epistlers1154113epistlers
epistyles1454143epistyles
gristle8169223gristle_
hantles104117513_hantles
hassles103411693_hassles
hastes95727073_hast_es
higgles123911803_higgles
hiltless11297123_hiltless
hirples12149643_hirples
hirsles101510073_hirsles
hisses94719353_his_ses
hissies103915823_hissies
histed104420243_hist_ed
histones11312803_histones
hists86328373_hist__s
hitless103211193_hi_tless
hostels103712313_hostels
hostiles11312213_hostiles
hostler103411023_hostler
hostlers113310483_hostlers
hurtles103913753_hurtles
hustle93113993_hustle_
hustled113210133_hustled
hustler103410753_hustler
hustlers11349203_hustlers
isles54220563__is_les
istle52214713__istle_
ixtles13217063__ixtles
jostles143411143_jostles
justles143311433_justles
kirtles11309663_kirtles
kittles113012493_kittles
lisles63416283_lis_les
listees73416673_listees
listels74212433_listels
listless8269263_listless
littles73212783_littles
nestles73015463_nestles
pestles93217693_pestles
philtres1396513philtres
pintles94118723_pintles
pistes85325633_pist_es
pistoles102514723_pistoles
rustles73416413_rustles
shiftless15265303shiftless
shingles123111113shingles
shirtless12266413shirtless
shists96515113shist__s
shitless11249243shi_tless
shuttles1136553shuttles
skittles1245763skittles
spittles1038333spittles
thimbles1536023thimbles
thirties1139723thirties
thistlier1243653thistlier
thistliest1344383thistliest
thistly1395963thistl_y
throstles1265903throstles
titles63719923_ti_tles
tittles73413253_tittles
trestles83012553trestles
vittles103211113_vittles
waisted114210943waist_ed
waister103812383waist_er
waisters113811523waisters
waistlines1343893waistlines
waists97415453waist__s
warsles103413643wars_les
warstle10328013warstle_
warstled12286123warstled
warstler11275933warstler
warstlers12284713warstlers
wastes96224883w_ast_es
wattles103814073w_attles
whales124716943wh__ales
wheatless1534003wheatless
wheedles1534643wheedles
wheeples1634743wheeples
whiffle1933533whiffle_
whiffled2133043whiffled
whiffler2033483whiffler
whifflers2142773whifflers
while115418693whi__le_
whiled134514133whi__led
whimsies1635193whimsies
whines125120103whi__nes
whinges143610633whi_nges
whinnies14237273whinnies
whinstones1644233whinstones
whipstalls1852313whipstalls
whirled14368043whi_rled
whirler13307603whi_rler
whirlers14286053whi_rlers
whirlies14167373whirlies
whirls124710533whi_rl_s
whirries14136693whirries
whished17428023whis_hed
whishted1843153whishted
whishts16425313whis_hts
whisked18336913whis_ked
whisker17367933whis_ker
whiskers18306773whiskers
whiskey20445583whis_key
whiskeys21353383whiskeys
whisks16497353whis__ks
whisper15298013whis_per
whispers16266993whispers
whist115322953whist___
whisting15329543whisting
whistling1644733whistling
whistlings1742913whistlings
white114920303whi_t_e_
whited134814083whi_t_ed
whitely16346473whi_tely
whiten124111923whi_t_en
whitens13428733whi_tens
whiter124316393whi_t_er
whitest133710113whi_t_est
whitey154911883whi_t_ey
whiteys16396153whi_teys
whither163510253whi_ther
whitier133311063whi_tier
whitiest14259883whi_tiest
whitlow1642853whi_tlow
whitlows1743083whi_tlows
whits115923823whi_t__s
whitter139110893whi_tter
whitters14359403whitters
whittret1445893whittret
whittrets1542493whittrets
whizzes2134713whi_zzes
wholes124616773wh__oles
whortle13335943whortle_
whosises1435333whosises
widdles123514343w_iddles
wiggles123312463w_iggles
wiles85437873w_i__les
wimbles143010853w_imbles
wimples143311173w_imples
windles113518493w_indles
winkles143412773w_inkles
wintle94014603w_intle_
wintled11339843w_intled
wises85633193w_is__es
wishes124920953w_is_hes
wishless1435993w_ishless
wisses94619603w_is_ses
wisted104120273w_ist_ed
wists86728523w_ist__s
wites85536963w_i_t_es
withes124620843w_i_thes
witless103310983w_i_tless
wrassles11376713wrassles
wrastle10368993wrastle_
wrastled12346433wrastled
wrestle10298843wrestle_
wrestled12296763wrestled
wrestler11306993wrestler
wrestlers12306103wrestlers
wriggles13286263wriggles
wrinkles15296693wrinkles
wristier1136863wristier
wristiest1237753wristiest
wrists95415643wrist__s
writes94420333wri_t_es
writhes134811703wri_thes

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 Filter1786911461620.1701051123.5
2DLD Change Limit1461622268.45317291.1
3Display Results2262260.0932430.1
 (SQL Overall)1786912268.71620501.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.