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 “busters” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

164 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
busters9472413(None) 
basters94930301basters
bisters93922611bisters
blusters104413891blusters
bunters94717121bunters
bursters1038981bursters
bushers124018801bushers
buskers133414091buskers
buster84726491buster_
bustiers103810051bustiers
bustlers104210611bustlers
butters94521721butters
dusters84918361dusters
justers143815731justers
lusters73921441lusters
musters94522511musters
ousters74122791ousters
abusers94710552abus_ers
abutters1056992abutters
asters65631602_asters
austere7312992austere
baiters94619302baiters
balusters1136642balusters
banters94623112banters
barters94223032barters
bashers124820832bashers
baster85333592baster_
bastes85330382baste_s
batters94626012batters
beaters94925042beaters
belters93819412belters
bestirs9311132bestirs
betters94422092betters
bister84922762bister_
bistres94017212bistres
biters83925242b_iters
bitters94920362bitters
blasters104116142blasters
blisters104015082blisters
blurters10348372blurters
blushers133911292blushers
bluster94215312bluster_
blustery13368002blustery
boasters103915662boasters
boaters93419242boaters
bolsters103712452bolsters
bolters94017802bolters
boosters104013442boosters
bruiters10329142bruiters
brushers134210572brushers
buckers153517452buckers
budders113812102budders
budgers114314922budgers
buffers153310792buffers
buggers114315662buggers
buglers105115322buglers
bulgers105215142bulgers
bummers133712442bummers
bumpers133912052bumpers
bunkers133715952bunkers
bunter85020382bunter_
burgers103918572burgers
buriers94017192buriers
burkers133716622burkers
burlers94120272burlers
burners94115672burners
burrers93814492burrers
burster9310292burster_
busbars1138152busbars
buses75936012bus_e_s
bushels124110712bushels
busher114922202busher_
bushes115226112bushe_s
busier85219722busier_
busies85525262busie_s
busker125517832busker_
busses85023382busse_s
bustard10389722bustard
bustards11308512bustards
busted95123152buste_d
bustics11810882bustics
bustier93916152bustier_
bustler94012562bustler_
bustles93816322bustles
busts75227692bust__s
buteos84913412bu_teos
butes714535872bu_te_s
butlers94518052butlers
butter84724232butter_
buttery124311192buttery
buttes84822562butte_s
buyers114511002bu_yers
buzzers17347172buzzers
casters94729902casters
clusters102912402clusters
costers94128332costers
cussers94213402cussers
cutters94218962cutters
duster74919722duster_
easters75125682easters
esters64627732_esters
festers104121392festers
flusters113811502flusters
fosters104220102fosters
fussers104210812fussers
gasters85624292gasters
gushers113512512gushers
gutters83715512gutters
hunters103915732hunters
hurters103413642hurters
huskers143510042huskers
hustlers11349202hustlers
jesters144118192jesters
jousters153210422jousters
juster134617012juster_
lasters75627692lasters
listers74026532listers
luster64023672luster_
lustres73013232lustres
masters94628922masters
misters93927512misters
munsters104010552munsters
musers84719102mus_ers
mushers124016442mushers
mustees94614922mustees
muster84724522muster_
mutters94117142mutters
nesters74422792nesters
nutters74215432nutters
ouster64223732ouster_
outers64230172ou_ters
oysters103411692oysters
pasters94531732pasters
pesters93827092pesters
posters93928012posters
punsters103310582punsters
punters93617042punters
pushers123814502pushers
putters94219192putters
questers17168762questers
quoters16369262quoters
rasters74629022rasters
resters74130402resters
rosters73727542rosters
rousters84315682rousters
rushers103816102rushers
rustlers8339852rustlers
sisters73721592sisters
suiters73618882suiters
tasters74225642tasters
testers74124542testers
trusters83112262trusters
tufters10298352tufters
tuskers113710042tuskers
tussers74313562tussers
ulsters72711982ulsters
users55817572_us_ers
ushers94415532_ushers
utters63817122_utters
wasters104026592wasters
westers105221962westers
xysters17307162xysters
zesters163517292zesters
zosters163015412zosters

Search took 4 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 Filter1786911076710.393454684.5
2DLD Change Limit1076711643.04635348.3
3Display Results1641640.0602733.3
 (SQL Overall)1786911643.49951069.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.