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

146 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
busher11492220(None) 
basher115123811basher
blusher124113111blusher
brusher123813001brusher
bushed124822381bushed
bushel114513941bushel
bushers124018801bushers
bushes115226111bushes
bushier123712811bushier
busier85219721busier
busker125517831busker
buster84726491buster
gusher104115771gusher
lusher93818761lusher
musher113820571musher
pusher114318281pusher
rusher94019651rusher
usher84517761_usher
abuser85413682abus_er
ambusher1544112ambusher
baser74828922bas_er
bashed126225702bashed
bashers124820832bashers
bashes115631392bashes
baster85333592baster
bather115322512bather
bister84922762bister
blucher143310222blucher
blushed134411752blushed
blushers133911292blushers
blushes124314822blushes
bluster94215312bluster
boshes114721882boshes
bosker123813652bosker
bother115218062bother
brasher124515242brasher
brushed133811212brushed
brushers134210572brushers
brushes124014662brushes
brushier13306972brushier
brusker13437852brusker
bucker145420462bucker
budder104314812budder
budger104617712budger
buffer144512682buffer
bugger104418722bugger
bugler94717722bugler
buhr95315382bu_h_r
bulger94917352bulger
bummer124014102bummer
bumper123714342bumper
bunker124519372bunker
bunter85020382bunter
burger94020792burger
burgher1337002burgher
burier84324652burier
burker125221172burker
burler84723832burler
burner83819202burner
burrer83718472burrer
burster9310292burster
busbar1038452busbar
bused85624492bus_ed
buses75936012bus_es
bush96630712bush__
busheler1374762busheler
bushels124110712bushels
bushmen1436302bushmen
bushwa14105142bushwa
bushy135416682bush_y
busied95117222busied
busies85525262busies
busked134917702busked
buskers133414092buskers
busmen1039892busmen
bussed94717052bussed
busses85023382busses
busted95123152busted
busters94724132busters
bustier93916152bustier
bustler94012572bustler
butcher143411162butcher
butler84220032butler
butter84724232butter
buyer105013092bu_yer
buzzer16379112buzzer
cosher114819902cosher
crusher124412322crusher
cushier123610832cushier
cusser86016092cusser
dasher104318982dasher
duster74919722duster
fisher124917142fisher
flusher133012272flusher
fusser94813772fusser
gasher104320372gasher
gushed114816242gushed
gushers113512512gushers
gushes104719032gushes
gushier113110072gushier
hushed134416672hushed
hushes124718592hushes
husker134212702husker
josher164312962josher
juster134617012juster
kasher134915032kasher
kosher134412972kosher
lasher94824532lasher
lushed104218722lushed
lushes94022742lushes
luster64023672luster
masher114123202masher
mosher114719792mosher
muser76024122mus_er
mushed124420842mushed
mushers124016442mushers
mushes114124562mushes
mushier123813592mushier
muster84724522muster
nosher94616362nosher
ouster64223732ouster
pisher114317752pisher
plusher124010382plusher
posher115018162posher
pushed125017462pushed
pushers123814502pushers
pushes114621662pushes
pushier123611092pushier
quasher19198622quasher
rasher95024122rasher
rushed104419862rushed
rushee93818772rushee
rushers103816102rushers
rushes94724362rushes
rushier103411972rushier
shusher13288112shusher
tushed104615892tushed
tushery1335632tushery
tushes94319472tushes
tusker104212192tusker
tusser64615832tusser
user45023002_us_er
ushers94415532_ushers
washer124720392washer
wisher123617062wisher
wuther124511612wuther

Search took 3 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 Filter178691825510.346516448.0
2DLD Change Limit825511462.31335690.0
3Display Results1461460.0463173.9
 (SQL Overall)1786911462.70566059.5
 
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.