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

158 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
bottlings1221529(None) 
bottling11279141bottling_
bantlings12216602bantlings
battings114010572batt_ings
battling113110492battling_
bittings11339292bitt_ings
boatings113710112boat_ings
botulins1047062botulin_s
botulinus1142752botulinus
bowlings14408752bo_wlings
fettlings1353752fettlings
jottings16275192jott_ings
mottling11197752mottling_
rattlings10235512rattlings
settlings1054682settlings
babblings13194373babblings
bantling112612003bantling_
bastings114214693bast_ings
batting104422273batt_ing_
beatings114113233beat_ings
beetling1139283beetling_
bellings113811153b_ellings
beltings11369253belt_ings
beltlines1135963beltlines
betting103921403bett_ing_
billings113412633b_illings
birlings11359613b_irlings
birthings15254623birthings
bitewings1542943bitewings
bitting103717293bitt_ing_
blotting113910433blott_ing_
boardings13296063boardings
boating103721303boat_ing_
boatlifts1442383boatlifts
bobbling12238643bobbling_
bobolinks1742493bobolinks
bodings113711653bo__dings
boggling13257163boggling_
boiling103819673bo_iling_
boings96416873bo___ings
bolling103820883bo_lling_
bolting104416763bolt_ing_
bombings15266493bo_mbings
bondings12369413bo_ndings
boodling121910243boodling_
bookings15358733bo_okings
booting103821363boot_ing_
bootlegs11325873bootl_egs
bootlicks17103903bootlicks
borings103614243bo__rings
botching16359703botching_
botflies1336733botfli_es
bottlers103810013bottl_ers
bottles94216273bottl__es
bottoming1444433bottoming_
botulin947653botulin__
botulinal1142833botulinal
botulinum1351933botulinum
botulinums1451423botulinums
botulisms1345303botulisms
boweling143410683boweling_
bowings133612003bo__wings
bowlines133211623bo_wlines
bowling133916493bo_wling_
bowstrings16173223bowstrings
boxings17429163bo__xings
brattling1236003brattling_
brislings12236363brislings
brittling1235543brittling_
bumblings16194753bumblings
bundlings13235563bundlings
bunglings13235213bunglings
buntings11348773bunt_ings
buntlines11207153buntlines
bustlines11207353bustlines
bustling112110063bustling_
butling103516813b_utling_
butting103519283butt_ing_
catlings113712043_catlings
chitlings15255903chitlings
coatings113811843coat_ings
codlings123110103co_dlings
couplings1435543couplings
cowlings14359773co_wlings
cuttings11277613cutt_ings
cuttling1138203cuttling_
dotting93314483dott_ing_
fatlings12359303_fatlings
fettling1266773fettling_
fittings12318203fitt_ings
flatlings13315823flatlings
fondlings14224893fondlings
footings12248833foot_ings
footling12239923footling_
foulings12327943fo_ulings
fowlings15377243fo_wlings
godlings11367493go_dlings
goslings10297553go_slings
guttling1037293guttling_
hotlines11811643ho_tlines
hotlinks1574193ho_tlinks
hotting113116523hott_ing_
jostling16207123jostling_
jotting152912773jott_ing_
kitlings13318103_kitlings
kittling1336063kittling_
knottings14243073knott_ings
loathings1344213loathings
lordlings1143923lordlings
lotting82917753lott_ing_
mantlings12207233mantlings
mattings11369673matt_ings
modelings1335563modelings
motorings1245973motorings
nestlings1074313nestlings
nettings9288103nett_ings
nettling957213nettling_
northings13185573northings
nothings12266683no_things
nuttings9276783nutt_ings
outings84014753_out_ings
outlines82418093_outlines
outrings92811053_outrings
outsings93410333_outsings
pettings11349703pett_ings
pettling1168213pettling_
pittings11349123pitt_ings
postings112912303post_ings
potlines10714213po_tlines
potting103720893pott_ing_
rattling92510873rattling_
rebottling1343733rebottling_
rocklings16224843rocklings
rollings9419953ro_llings
rootling9269953rootling_
rotting82919683rott_ing_
settings93810073sett_ings
settling978943settling_
sittings9339733sitt_ings
southings13246233southings
stylings12276233_stylings
tattings9408823tatt_ings
tattling9259473tattling_
tilings84212793__tilings
toolings9248473to_olings
tootling9279523tootling_
totaling9610303totaling_
totting82816843tott_ing_
towelings13234693towelings
turtlings10184873turtlings
unbottling1343133unbottling_
vittling1236143vittling_
wattling12258783wattling_
wettings12348403wett_ings
whittlings1742223whittlings
witlings12328443_witlings
wittings12328733witt_ings
wotting112913843wott_ing_

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.1701051123.5
2DLD Change Limit1486411586.17324079.2
3Display Results1581580.0632507.9
 (SQL Overall)1786911586.40627894.3
 
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.