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

123 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
dabblings1519388(None) 
babblings13194371babblings
dabbling14227971dabbling_
ablings1038742_a_blings
babbling12228692babbling_
dabbing133511232dabb_ing_
darklings1533982darklings
darlings103710382da_rlings
dibbling14247332dibbling_
drabbling1544552drabbling_
dubbings14245472dubb_ings
gabbling14238072gabbling_
marblings14225542marblings
rabbling13239332rabbling_
wabbling16207742wabbling_
ablins8316193_a_blin_s
aiblins9311473_aiblin_s
ambling121411793_ambling_
anglings10228273_anglings
bantlings12216603bantlings
bedabbling1542293bedabbling_
bobbling12238643bobbling_
brabbling1334963brabbling_
bramblings1742613bramblings
bubbling12248223bubbling_
bumblings16194753bumblings
cabbing143613153cabb_ing_
cabling124017553ca_bling_
cagelings1335413cagelings
callings113613833ca_llings
carlings114015853ca_rlings
catlings113712043ca_tlings
cobbling15248803cobbling_
cymblings1942663cymblings
dabblers13379363dabbl_ers
dabbles124514773dabbl__es
daddling12258233daddling_
daggling12237063daggling_
dairyings1442633dairyings
dampings14377523da_mpings
dandling112511733dandling_
dangling112611233dangling_
dappling1436843dappling_
darings93713653da__rings
darkling1437483darkling_
darling93418363da_rling_
darnings10378553da_rnings
dartling1039563dartling_
datelines1088853datelines
daubing11358623daub_ing_
dawdling14236373dawdling_
dazzling1834363dazzling_
dealings103510703d_ealings
dialings10329823d_ialings
diallings1134993diallings
dibbing133110893dibb_ing_
dobbins12379533dobb_in_s
doubling1238153doubling_
drabbing14286803drabb_ing_
dribbling1533713dribbling_
drillings11285823drillings
drubbings15262883drubbings
dubbing133311213dubb_ing_
dubbins12358803dubb_in_s
ducklings17204013ducklings
dumplings15213853dumplings
dwellings14244213dwellings
eanlings9128473ea_nlings
fabling133413623fa_bling_
failings123811013fa_ilings
fatlings12359303fa_tlings
gabbing133512033gabb_ing_
gabling113514543ga_bling_
gambling14218963gambling_
garbling12249453garbling_
gobbling14257533gobbling_
grabbling1564583grabbling_
handlings14237343handlings
hobbling16227583hobbling_
jabbing19319413jabb_ing_
kibbling17225703kibbling_
labeling11311643labeling_
mailings113011923ma_ilings
mallings113413093ma_llings
mantlings12207233mantlings
marbling13179883marbling_
marlings113713493ma_rlings
nabbing12299963nabb_ing_
nibbling13256503nibbling_
nobbling13228273nobbling_
paddlings14224363paddlings
palings103915823pa__lings
panelings12107453panelings
pebbling1535073pebbling_
rabbins112811343rabb_in_s
railings93412153ra_ilings
rambling131810773rambling_
rattlings10235513rattlings
ravelings13377383ravelings
ribbings13275923ribb_ings
rubbings13306333rubb_ings
rubbling13238073rubbling_
rumblings14184633rumblings
sabbing123314743sabb_ing_
sailings93513253sa_ilings
samplings1435553samplings
sandlings11238093sandlings
saplings11269803sa_plings
scabbling1634863scabbling_
siblings11108123_siblings
stablings12256103stablings
subbings13238483subb_ings
tabbing123611913tabb_ing_
tabbying1633973tabbying_
tabling103216033ta_bling_
tacklings16235853tacklings
tailings93211673ta_ilings
tumblings14184843tumblings
wafflings1943023wafflings
wambling16198443wambling_
warbling14198943warbling_
webbings1633243webb_ings
wobbling16246923wobbling_

Search took 7 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.436409841.7
2DLD Change Limit1486411236.19024013.1
3Display Results1231230.0631952.4
 (SQL Overall)1786911236.68926714.2
 
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.