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

167 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
bustline1020884(None) 
buntline10198061buntline
bustlines11207351bustlines
bustling112110061bustling
baseline10310752baseline
beltline1036942beltline
bubaline1247162bubaline
buntlines11207152buntlines
bushlike1734962bushlike
busting104221792bust_ing
bustle84015482bustl__e
butling103516812bu_tling
cutline92914542cu_tline
dustlike1335362dustlike
hustling12228792hustling
justling16207252justling
musteline1146972musteline
outline72321332ou_tline
rustling9249982rustling
auntlike1234983auntlike
baculine1238983baculine
balkline1437973balkline
bantling112612003bantling
basaltine1144713basaltine
baseliner1144753baseliner
baselines1138603baselines
bastile9313913bast_ile
bastille1048003bastille
basting104227203bast_ing
batlike133311883b_atlike
battling113110493battling
beeline93314723b_eeline
beetling1139283beetling
beltlines1135963beltlines
berline93716853b_erline
beryline1337083beryline
beslime1146833bes_lime
besting104923923best_ing
bestride1138613bestride
betaine9413783b_etaine
blueline1036873blueline
boatlike1457963boatlike
boltlike1436313boltlike
bottling11279143bottling
bowline123613113b_owline
bristling1246663bristling
bubbling12248223bubbling
buckling17259113buckling
budlike14257873bu_dlike
bugling113615343bu_gling
bulling104324793bu_lling
bumbling15249763bumbling
bundling12219703bundling
bungling12269543bungling
bunting103718833bunt_ing
burbling13249423burbling
burgling12239303burgling
burling104421133bu_rling
bursting1138703burst_ing
burstone1057133burst_one
busheling1535503busheling
bushfire1642603bushfire
bushing134018583bus_hing
bushland1444193bushland
busing96420593bus__ing
buskin123811493bus_kin_
buskined1534443bus_kined
busking144116573bus_king
buskins133310943bus_kins
bussing103614623bus_sing
bustic101012693bust_i_c
bustics11810883bust_ics
bustier93916153bust_ier
bustiness111810483bust_iness
bustled104011523bustl_ed
bustler94012573bustl_er
bustlers104210623bustlers
bustles93816323bustl_es
bustlingly1643063bustlingly
busying134211993bus_ying
butane8313653bu_t_ane
butene8312623bu_t_ene
butle75023103bu_tl__e
butting103519283bu_tting
butylene1344403butylene
byline11311643b__yline
castling11311233castling
coastline1196363coastline
cultlike1434933cultlike
cutlines102413273cu_tlines
cuttling1138203cuttling
cysteine1345333cysteine
cystine1239333cyst_ine
destine83719953dest_ine
dustbin1044543dustbin_
dustbins1144593dustbins
dusting93618993dust_ing
fishline14237583fishline
flatline11298923flatline
frostline1245883frostline
fuselike1535673fuselike
gantline9410903gantline
gasoline938523gasoline
gumline102810113gu_mline
gusting93917163gust_ing
gutlike12308653gu_tlike
guttling1037293guttling
guyline11258173gu_yline
hotline10712353_hotline
hurtling12318313hurtling
husklike1433613husklike
hustle93113993hustl__e
hutlike14349063hu_tlike
isoline7314013_isoline
jostling16207123jostling
justice1637423just_ice
justing153615163just_ing
justle133211583justl__e
lusting83619323lust_ing
lustring9269723lustring
mastlike1437863mastlike
multiline1149123multiline
muscling1337853muscling
muslin8312213mus_lin_
muslins9312213mus_lins
musting103221073must_ing
mutine84420373mu_t_ine
nestlike1236083nestlike
nestling958893nestling
nutlike113110113nu_tlike
ousting84021353oust_ing
outlie62419533ou_tli_e
outlined92512953ou_tlined
outliner82412113ou_tliner
outlines82418093ou_tlines
outlive102513033ou_tlive
outshine11310723outshine
pestling111010253pestling
plotline1037643plotline
potline91015233_potline
purline93516533pu_rline
puslike1347563pus_like
pusslike1434033pusslike
ratline74517803_ratline
rushlike1534333rushlike
rusine63916593rus__ine
rusting83821263rust_ing
rustle63615413rustl__e
saline65132703__saline
sestine73017923sest_ine
setline7313923_setline
spline86020533__spline
subline9316893su_bline
suitlike1236313suitlike
sustain738773sustain_
sustained1045383sustained
sustainer944783sustainer
sustains838553sustains
trotline8310023trotline
tumpline1237113tumpline
turtling9238833turtling
tusklike1133583tusklike
tussling935823tussling
untwine1038623_untwine
vaseline1138613vaseline
vestlike1535393vestlike
waistline1244173waistline

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 Filter1786911461620.453394461.4
2DLD Change Limit1461621677.96618348.2
3Display Results1671670.1101518.2
 (SQL Overall)1786911678.52920951.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.