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

132 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
babblings1319437(None) 
babbling12228691babbling_
dabblings15193881dabblings
ablings1038742_a_blings
bantlings12216592bantlings
bobbling12238642bobbling_
brabbling1334962brabbling_
bramblings1742602bramblings
bubbling12248222bubbling_
bumblings16194752bumblings
dabbling14227972dabbling_
gabbling14238072gabbling_
marblings14225532marblings
rabbling13239332rabbling_
wabbling16207742wabbling_
ablins8316193_a_blin_s
aiblins9311473_aiblin_s
ambling121411783_ambling_
anglings10228273_anglings
babbitts1144023babb_itts
babblers113510353babbl_ers
babbles104416323babbl__es
babying1537963ba_bying_
backings174012213ba_ckings
baffling1756053baffling_
baggings13307523ba_ggings
bailing103723523ba_iling_
bakings144312013ba__kings
baling94829693ba__ling_
balklines1536743balklines
balling104424763ba_lling_
bambinos1443873bamb_inos
bankings15489403ba_nkings
bantling112611993bantling_
barbing123716993barb_ing_
baselines1138603baselines
bashings144311243ba_shings
bastings114214693ba_stings
battings114010573ba_ttings
battling113110493battling_
bawling133813863ba_wling_
bedabbling1542293bedabbling_
bellings113811153b_ellings
bibbing11299603bibb_ing_
billings113412633b_illings
birlings11359613b_irlings
blabbing12266723blabb_ing_
blebbings13242783blebbings
bobbing113113193bobb_ing_
bobbins103410343bobb_in_s
bobolinks1742493bobolinks
bombings15266493bomb_ings
bottlings12215293bottlings
bowlings14408753b_owlings
brambling1635543brambling_
brandlings1443993brandlings
brislings12236363brislings
bubblies1166773bubbli_es
bumbling15249763bumbling_
bundlings13235563bundlings
bunglings13235213bunglings
burbling13249423burbling_
cabbing143613153cabb_ing_
cabling124017553ca_bling_
cagelings1335413cagelings
callings113613833ca_llings
carlings114015853ca_rlings
catlings113712043ca_tlings
cobbling15248803cobbling_
cymblings1942653cymblings
dabbing133511233dabb_ing_
darklings1533983darklings
darlings103710383da_rlings
dibbling14247333dibbling_
drabbling1544553drabbling_
dubbings14245473dubb_ings
eanlings9128463ea_nlings
fabling133413623fa_bling_
failings123811013fa_ilings
fatlings12359303fa_tlings
gabbing133512033gabb_ing_
gabling113514543ga_bling_
gambling14218963gambling_
garbling12249453garbling_
gobbling14257533gobbling_
grabbling1564583grabbling_
handlings14237333handlings
hobbling16227583hobbling_
jabbing19319413jabb_ing_
kibbling17225703kibbling_
labeling11311643labeling_
mailings113011923ma_ilings
mallings113413093ma_llings
mantlings12207223mantlings
marbling13179883marbling_
marlings113713483ma_rlings
nabbing12299963nabb_ing_
nibbling13256503nibbling_
nobbling13228273nobbling_
paddlings14224353paddlings
palings103915823pa__lings
panelings12107453panelings
pebbling1535073pebbling_
rabbins112811343rabb_in_s
railings93412153ra_ilings
rambling131810773rambling_
rattlings10235513rattlings
ravelings13377383ravelings
ribbings13275923ribb_ings
rubbings13306333rubb_ings
rubbling13238073rubbling_
rumblings14184623rumblings
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 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.1701051123.5
2DLD Change Limit1486411327.50019818.8
3Display Results1321320.1101200.0
 (SQL Overall)1786911327.78022968.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.