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

125 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
warstlers1228471(None) 
warslers11328071wars_lers
warstler11275931warstler_
warstles11368801warstle_s
waisters113811522waist_ers
waistless1235092waistless
warblers13319102war_blers
warsler10289892wars_ler_
warsles103413642wars_le_s
warstle10328012warstle__
warstled12286122warstle_d
wartless11279922war_tless
wasters104026592wa_st_ers
whistlers1595162whistlers
wrastles11328932wrastle_s
wrestlers12306102wrestlers
antlers74014743_a_ntlers
artless73712513_ar_tless
ashlers10319583_a_shlers
asters65631603_a_st_ers
barters94223033bar_t_ers
basters94930303ba_st_ers
battlers104110973ba_ttlers
bursters1038983burst_ers
bustlers104210613_bustlers
carolers103314173car_olers
carollers1137703carollers
carters95327253car_t_ers
casters94729903ca_st_ers
castles94917733ca_stle_s
dabsters1137053dabst_ers
darters84017603dar_t_ers
dartles84014133dar_tle_s
easters75125683ea_st_ers
epistlers1154113epistlers
fartleks1533963far_tleks
gagsters10317083gagst_ers
garblers113810283gar_blers
garglers10418263gar_glers
garotters1055033garotters
garters84218233gar_t_ers
gasters85624293ga_st_ers
hamsters13710423hamst_ers
harslets1137833hars_lets
hostlers113310483_hostlers
hustlers11349203_hustlers
jostlers15357683_jostlers
lamsters1099753lamst_ers
lasters75627693la_st_ers
marblers12319233mar_blers
martlets103310483mar_tlets
masters94628923ma_st_ers
mastless102610023ma_stless
nestlers8359223_nestlers
ostlers72911203__ostlers
parsers94118153pars__ers
parsleys1335083pars_leys
partiers103514243par_tiers
partlets102811513par_tlets
partners102711133par_tners
partyers13277763par_tyers
pasters94531733pa_st_ers
pastless102411203pa_stless
prattlers11195323prattlers
rasters74629023ra_st_ers
rattlers83510293ra_ttlers
rustlers8339853_rustlers
startlers9236743star_tlers
tapsters10318803tapst_ers
tarsiers8298533tars_iers
tartlets8289663tar_tlets
tasters74225643ta_st_ers
tattlers8369693ta_ttlers
turtlers8258203tur_tlers
wabblers15398993wa_bblers
waddlers13298333wa_ddlers
wafflers17306323wa_fflers
wafters134112813wa_ft_ers
wailers103916803wa__ilers
waister103812383waist_er_
waiters104218623wa_it_ers
walers94824463wa___lers
waltzers2034003wa_ltzers
wanglers123310033wa_nglers
wanters104420093wa_nt_ers
warbler123211463war_bler_
warbles123215563war_ble_s
warders113416813war__ders
wardless12249303war_dless
warless104015103war__less
warmakers1845633warmakers
warmers124514293war__mers
warners103315563war__ners
warpers123413583war__pers
warpowers1744553warpowers
warreners1236193warreners
warsle93112923wars_le__
warsled112910443wars_le_d
warstling1335063warstling
wartier103413913war_tier_
washers134517523wa_s_hers
wassailers1342343wassailers
waster95228943wa_st_er_
wastery134610993wa_st_ery
wastes96224883wa_st_e_s
wastrels1136203wa_strels
waters95030633wa__t_ers
wattles103814073wa_ttle_s
wattless11268723wa_ttless
websters1335803webst_ers
westers105221963w_est_ers
whistler1496313whistler_
whistles14108213whistle_s
whittlers1594333whittlers
worsteds1234483worst_eds
wranglers1344273wranglers
wrassles11376713wrassle_s
wrastle10368993wrastle__
wrastled12346433wrastle_d
wresters112711733wrest_ers
wrestler11306993wrestler_
wrestles113310063wrestle_s
wristlets1244473wristlets
writers105513493w_rit_ers
writhers14398983w_rithers

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 Filter1786911486410.423422437.4
2DLD Change Limit1486411257.81319024.8
3Display Results1251250.0462717.4
 (SQL Overall)1786911258.28221575.8
 
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.