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

147 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
whistlers159516(None) 
whistler1496311whistler_
whistles14108211whistle_s
whittlers1594331whittlers
chiselers1445452chiselers
epistlers1154112epistlers
hostlers113310482_hostlers
hustlers11349202_hustlers
thistles1198232thistle_s
waisters113811522waist_ers
waistless1235092waistless
warstlers12284712warstlers
whifflers2142772whifflers
whirlers14286052whi_rlers
whiskers18306772whis_kers
whispers16266992whis_pers
whistle13107532whistle__
whistled1595782whistle_d
whitters14359402whi_tters
whittler1495192whittler_
whittles1496672whittle_s
wrestlers12306102wrestlers
wristlets1244472wristlets
bhisties1339003bhistie_s
bisters93922613_bist_ers
blisters104015083blist_ers
bristles101510433bristle_s
bustlers104210613_bustlers
chillers133710923chi_llers
chiseler1335903chiseler_
chisellers1543083chisellers
chitters133711173chi_tters
chortlers14305663chortlers
epistler1044833epistler_
epistles1047783epistle_s
epistolers1243183epistolers
glisters93912603glist_ers
gristers94013403grist_ers
gristles9189203gristle_s
heisters113413133heist_ers
higglers13297233_higglers
hillers103718733_hi_llers
hiltless11297123_hiltless
hinters103719583_hint_ers
hipsters13268793_hipst_ers
hissers104112313_his_sers
hitless103211193_hi_tless
hitters104717593_hi_tters
hoisters113513483hoist_ers
hostelers1246633_hostelers
hostler103411023_hostler_
hustler103410753_hustler_
hustles103414173_hustle_s
istles62814983__istle_s
jostlers15357683_jostlers
keisters123212043keist_ers
klisters123910483klist_ers
leisters83312823leist_ers
listers74026533_list_ers
listless8269263_listless
meisters103313843meist_ers
misters93927513_mist_ers
nestlers8359223_nestlers
ostlers72911203__ostlers
philters1398173philt_ers
roisters83615553roist_ers
rustlers8339853_rustlers
shifters14319863shift_ers
shiftless15265303shiftless
shinglers13246443shinglers
shirtless12266413shirtless
shitless11249243shi_tless
shuttlers1254123shuttlers
shysters14106463shyst_ers
sisters73721593_sist_ers
thirsters1235233thirst_ers
thistle10107803thistle__
thistlier1243653thistlier_
twisters11268173twist_ers
wailers103916803wai__lers
waister103812383waist_er_
waiters104218623wai_t_ers
warslers11328073wars_lers
warstler11275933warstler_
warstles11368803warstle_s
wasters104026593w_ast_ers
websters1335803webst_ers
westers105221963w_est_ers
whalers13529703wh__alers
wheatless1534003wheatless
wheedlers1643193wheedlers
wheelers14287733wh_eelers
whetters14246653wh_etters
whickers20297983whi_ckers
whiffers2064493whi_ffers
whiffler2033483whiffler_
whiffles2034263whiffle_s
whiles124418013whi__le_s
whimpers18276613whi_mpers
whiners134011573whi__ners
whingers15358723whi_ngers
whippers18329043whi_ppers
whirler13307603whi_rler_
whishes16309443whis_he_s
whisker17367933whis_ker_
whiskery21314553whis_kery
whiskeys21353383whis_keys
whiskies1835953whiskie_s
whisper15298013whis_per_
whisperers18153053whisperers
whispery19284293whis_pery
whisted144010013whist_e_d
whistling1644733whistling
whistlings1742913whistlings
whists124613813whist___s
whiteners1535243whiteners
whitens13428733whi_t_ens
whiter124316393whi_t_er_
whites123919883whi_t_e_s
whiteys16396153whi_t_eys
whither163510253whi_ther_
whitier133311063whi_tier_
whities133113253whi_tie_s
whitlows1743083whi_tlows
whitter139110893whi_tter_
whittle13106103whittle__
whittled1594913whittle_d
whittrets1542493whittrets
whizzers2233423whi_zzers
whortles14306743whortle_s
wigglers13257213w_igglers
willers103517913w_i_llers
winters103720483w_int_ers
wintles103414983w_intle_s
wishers133215213w_is_hers
wishless1435993w_ishless
withers134417753w_i_thers
witless103310983w_i_tless
wrastles11328933wrastle_s
wresters112711733wrest_ers
wrestler11306993wrestler_
wrestles113310063wrestle_s
wrigglers14273713wrigglers
wristier1136863wristier_
wristlet1138643wristle_t
writers105513493wri_t_ers
writhers14398983wri_thers

Search took 10 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 Filter1786911486410.326548131.9
2DLD Change Limit1486411478.59617291.9
3Display Results1471470.0632333.3
 (SQL Overall)1786911478.98519887.7
 
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.