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

225 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
blastings1234791(None) 
bastings114214691b_astings
beastings12387651beastings
blasting114013431blasting_
lastings94214421_lastings
bashings144311242b_ashings
basting104227202b_asting_
battings114010572b_attings
beatings114113232bea_tings
beestings12335922beestings
biestings12266032biestings
blackings18316762blackings
bladings12337752bla_dings
blaggings14324462blaggings
blasties102113632blasti_es
blatting114111652blatting_
blessings1233722blessings
boasting113512502boasting_
boatings113710112boa_tings
castings113614052_castings
coastings12357862coastings
eastings93412952_eastings
elastins82111742elastin_s
fastings124011942_fastings
flashings16316662flashings
lashings124412252_lashings
lasting84725242_lasting_
listings93310042_listings
plaitings12296242plaitings
plantings12348402plantings
platings113611362pla_tings
slashings13316202slashings
slatings94011722sla_tings
slattings10346072slattings
ablating11312003abla_ting_
actings104512463__actings
aliasings1043653alias_ings
antings85015583__antings
askings12519173__askings
backings174012213b_ackings
baggings13307523b_aggings
baiting103918883b_aiting_
bakings144312023b_a_kings
ballasting1345303ballasting_
bankings15489403b_ankings
bantengs1134593b_antengs
bantlings12216603b_antlings
bashing135422583b_ashing_
basing95427663b_as_ing_
basins85722763b_as_in_s
basking144718613b_asking_
bastiles10313353b_astiles
bastions10411693b_astions
bating95132253b_a_ting_
batting104422273b_atting_
beadings123711783bea_dings
bearings113912253bea_rings
beasties102514653beasti_es
beating104326873bea_ting_
beeswings15293303beeswings
beltings11369253b_eltings
besting104923923b_esting_
biasing103512453bias_ing_
biassing11307263biassing_
bittings11339293b_ittings
blabbing12266723blabbing_
blacking174213603blacking_
blading113615363bla_ding_
blagging13319173blagging_
blains84516373bla__in_s
blaming123515693bla_ming_
blanking154411933blanking_
blaring104317113bla_ring_
blastemas1344693blastemas
blasters104116143blast_ers
blastie92411393blasti__e
blastier10249493blasti_er
blastiest111710053blastiest
blastments1444973blastments
blastoffs1743103blastoffs
blastomas1345523blastomas
blasts85116773blast___s
blastulas1143593blastulas
blawing134012753bla_wing_
blazing193612393bla_zing_
blazonings2241983blazonings
bleating113514503bleating_
blebbings13242783blebbings
bleedings13264643bleedings
blessing1137593blessing_
blissing1136873blissing_
bloating113512813bloating_
bloggings14264263bloggings
bloodings13245273bloodings
blotting113910433blotting_
blueings11305513bl_ueings
bluings10327963bl__uings
blunting11319843blunting_
blurting11258773blurting_
blushing14339333blushing_
boardings13296063boardings
boating103721303boa_ting_
boosting113311053boosting_
bowstrings16173223bowstrings
bracings13369293bra_cings
braidings13285903braidings
brandings13277483brandings
brassing112612303brassing_
breasting1239583breasting_
brislings12236363brislings
buntings11348773b_untings
bursting1138703bursting_
bushings14348793b_ushings
busings103711223b_us_ings
bussings11386663b_ussings
busting104221793b_usting_
casings104013513_cas_ings
casting104628343_casting_
chasings14318253chas_ings
claddings1433213claddings
clashing143812193clashing_
clasping133310263clasping_
classing113211793classing_
clastics122811413clasti_cs
closings11277673clos_ings
coasting113615513coasting_
coatings113811843coa_tings
crestings12298043crestings
draftings14334213draftings
dustings10419033_dustings
easting84924303_easting_
eatings84616443_ea_tings
elastics102710883elasti_cs
elastin72611843elastin__
elating83423083ela_ting_
fasting114522833_fasting_
feasting122011323feasting_
flaggings15285183flaggings
flashing153711553flashing_
flatlings13315823flatlings
flatting123511253flatting_
fleshings16335383fleshings
flutings12357373fl_utings
flytings15304793fl_ytings
frostings1335733frostings
gaskings14427473_gaskings
gassings10438403_gassings
gasting95022763_gasting_
gatings95212823_ga_tings
ghostings1433483ghostings
glassines10278043glassines
glassing10329973glassing_
glazings19325753gla_zings
gratings103910763gra_tings
hasting114725193_hasting_
hustings12378683_hustings
jestings16368023_jestings
kartings13418523_kartings
lacings105013653_la_cings
ladings93814133_la_dings
laggings11298403_laggings
lakings124713513_la_kings
landings103110073_landings
lapwings14274973_lapwings
lashing114422893_lashing_
lashins103915153_lashin_s
lasing74727983_las_ing_
lastingly1337243_lastingly
lathings12469853_lathings
latinas74416463_la_tinas
latinos73613803_la_tinos
lattins74115483_lattin_s
lawings113611473_la_wings
leasings9379843leas_ings
listing84020593_listing_
losings82810623_los_ings
lusting83619323_lusting_
lustrings10245553_lustrings
lutings83311053_l_utings
maskings15448753_maskings
masting104325823_masting_
matings104516213_ma_tings
mattings11369673_mattings
partings113513733_partings
passings11409873_passings
pastinas103712153_pastinas
pasting103826553_pasting_
plaiting113113513plaiting_
plankings16326113plankings
plannings12325453plannings
planting113515383planting_
plashing143311063plashing_
plasmins12199413plasmin_s
plasterings1444743plasterings
plastics122412333plasti_cs
plastids11269213plasti_ds
platinas103610313pla_tinas
plating103823073pla_ting_
platting114813033platting_
playthings1942363playthings
postings112912303_postings
raspings11337853_raspings
ratings84217413_ra_tings
roasting93012703roasting_
saltings92811253_saltings
seatings93614303sea_tings
shaftings16224183shaftings
skatings13326993ska_tings
slammings14234123slammings
slanting94115093slanting_
slashing123713413slashing_
slating83724653sla_ting_
slatting94014233slatting_
stings76220183___stings
tasting84624213_tasting_
tattings9408823_tattings
toasting93410583toasting_
twistings13264353twistings
vestings12359143_vestings
waistings1352710763waistings
waitings123413743_waitings
washings15419273_washings
wasting114422843_wasting_
westings12429803_westings
yeasting12188923yeasting_

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.453394461.4
2DLD Change Limit1486412258.11018328.1
3Display Results2252250.2031108.4
 (SQL Overall)1786912258.76620384.6
 
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.