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

140 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
warstling133506(None) 
warsling12198591wars_ling
wrastling1335521wrastling
castling11311232ca_stling
dartling1039562dar_tling
firstling1334422firstling
waisting123615212waist_ing
waistline1244172waistline
warbling14198942war_bling
wasting114422842wa_st_ing
wattling12258782wa_ttling
whistling1644732whistling
worsting1267682worst_ing
wrassling1334272wrassling
wrestling1336062wrestling
argling92812733_ar_gling
bantling112612003ba_ntling
barreling1238043barreling
basting104227203ba_st_ing
battling113110493ba_ttling
brattling1236003brattling
bristling1246663bristling
bursting1138703burst_ing
bustling112110063_bustling
capsuling1444533capsuling
carling103727063car__ling
caroling113317003car_oling
carolling1259413carolling
carting104228283car_t_ing
casting104628343ca_st_ing
catling104819793ca__tling
darkling1437483dar_kling
darling93418363dar__ling
darting94020663dar_t_ing
earthing12310323ear_thing
earthling1346193earthling
easting84924303ea_st_ing
farseeing1344383farseeing
farthing1538073far_thing
farting114120753far_t_ing
fasting114522833fa_st_ing
fatling113815683fa__tling
firstlings1442523firstlings
garbling12249453gar_bling
gargling11239203gar_gling
garoting10510703garot_ing
garotting1136103garotting
gasting95022763ga_st_ing
hairstyling1851923hairstyling
hamstring1546003hamstring
hanseling1338063hanseling
hassling1236803ha_ssling
hasting114725193ha_st_ing
hirseling1396273hirseling
hirsling1277543hirs_ling
hurtling12318313hur_tling
hustling12228793_hustling
jostling16207123_jostling
justling16207253_justling
karting123716063kar_t_ing
lasting84725243la_st_ing
mantling112012613ma_ntling
marbling13179883mar_bling
marling103322763mar__ling
marshaling1645083marshaling
marting103325013mar_t_ing
marveling1537103marveling
masting104325823ma_st_ing
morseling1238073morseling
nestling958893_nestling
nursling997603nurs_ling
parceling1438443parceling
parling103823763par__ling
paroling113316213par_oling
parsing103819553pars__ing
parting103527383par_t_ing
partying14168893par_tying
pasting103826553pa_st_ing
pestling111010253_pestling
prattling1246303prattling
rassling939013ra_ssling
rattling92510873ra_ttling
rustling9249983_rustling
startling1037373star_tling
tarting84222653tar_t_ing
tasseling1035853tasseling
tasting84624213ta_st_ing
tattling9259473ta_ttling
turtling9238833tur_tling
twattling1332693twa_ttling
wabbling16207743wa_bbling
waddling14237933wa_ddling
wadsetting1542913wadsetting
waffling1845423wa_ffling
wafting143911663wa_ft_ing
waggling14197063wa_ggling
wailing113620903wa__iling
waistings1352710763waist_ings
waistlines1343893waistlines
waiting113618953wa_it_ing
waling104525303wa___ling
walling113520973wa__lling
waltzing2134263wa_ltzing
wambling16198443wa_mbling
wangling132310993wa_ngling
wanting114220173wa_nt_ing
warding123918143war__ding
waring105029443war___ing
warking153519573war__king
warming133515083war__ming
warning113717093war__ning
warping133715183war__ping
warring113717973war__ring
warstle10328013warstl__e
warstled12286123warstl_ed
warstler11275933warstl_er
warstlers12284713warstlers
warstles11368803warstl_es
wartlike1537043war_tlike
washing145119283wa_s_hing
wassailing1443593wassailing
wauling112713113wa__uling
wawling143810963wa__wling
weaseling1335613weaseling
westing115020273w_est_ing
whisting15329543whist_ing
whistlings1742913whistlings
whittling1634383whittling
wintling12249923w_intling
wisting113519743w_ist_ing
witling113215813w__itling
worldling1442893worldling
worsening1345553worsening
worthing15178053wor_thing
wrangling1456223wrangling
wrathing15248923w_rathing
wresting123811833wrest_ing
wrestlings1442933wrestlings
writhing15278673w_rithing
writing113713893w_rit_ing

Search took 8 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.406440125.6
2DLD Change Limit1486411407.04621095.8
3Display Results1401400.0632222.2
 (SQL Overall)1786911407.51523777.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.