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

200 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
burse7552725(None) 
birse74517401birse
bourse84414331bourse
burke115122761burke
burs65847421burs_
bursa74921521bursa
bursae84515601bursae
burses84425511burses
burst75332241burst
curse75829141curse
nurse54420121nurse
purse76028891purse
abuse77119562abu_se
arse46539272_arse
aurae54128112aurae
aures55137092aures
barbe95328282barbe
barde85330772barde
bare65460522bar_e
bares75457132bares
barge85631022barge
barre75929542barre
bars66564092bars_
barye105021492barye
base64847022b_ase
becurse1136182becurse
berme96022942berme
birle75023632birle
birses84717732birses
bise66437092b_ise
blase75524232blase
blurs74619082blurs_
bore66051332bor_e
bores76448252bores
borne77926792borne
bourne83714092bourne
bourses94014302bourses
bouse75931852bouse
bowse105420632bowse
brae65639112b_rae
bree67241262b_ree
brie65837902b_rie
brose75227032brose
bruise83412872bruise
brume95817982brume
brush105917472brush
brusk114912432brusk
brute75321782brute
bubs86235492bubs_
budge94619872budge
buds75235172buds_
bugle84721942bugle
bugs76035912bugs_
buhrs104811242buhrs_
bulge86419872bulge
bums85934592bums_
buns66243722buns_
bur55744692bur__
bura66139532bur_a
buran75225302buran
buras74736292buras
burb85334672bur_b
burble104617702burble
burbs95423492burbs
burd75534262bur_d
burden9412472burden
burdie93615022burdie
burds84626062burds
buret77444012buret
burg74930362bur_g
burgee97120592burgee
burger94020792burger
burgh115216032burgh
burgle94815862burgle
burgs84924092burgs
buried94822372buried
burier84324652burier
buries84633272buries
burin75626062burin
burka114617692burka
burked135220882burked
burker125221172burker
burkes124421312burkes
burl64937182bur_l
burled94825382burled
burler84723832burler
burley114715752burley
burls74228852burls
burly104922832burly
burn65636422bur_n
burned95818962burned
burner83819202burner
burnet84326172burnet
burnie83715412burnie
burns74926772burns
burnt75230322burnt
burp85028882bur_p
burped116215502burped
burps94220172burps
burqa165013092burqa
burr65631232bur_r
burred95820722burred
burrer83718472burrer
burro75018492burro
burrs74925652burrs
burry105221562burry
bursal84414822bursal
bursar85413252bursar
bursas85318272bursas
bursate94111202bursate
burseed1049502burseed
bursera936762bursera
bursted1039422bursted
burster9310292burster
bursts85116242bursts
bury95633592bur_y
bus56950972bu_s_
bused85624492bu_sed
buses75936012bu_ses
bush96630712bu_sh
busk105429222bu_sk
buss65134912bu_ss
bussed94717052bussed
busses85023382busses
bust65947782bu_st
busy94727172bu_sy
bute66739672bu_te
butes714535872butes
butle75023102butle
buts67247692buts_
butte74924292butte
buys95726792buys_
byre95023852byr_e
byres104421382byres
carse74934332carse
corse75036182corse
course85117772course
cruse75726102cruse
cure66149122cur_e
cures75645432cures
curie74533032curie
curs65645542curs_
cursed94321252cursed
curser84721472curser
curses85328272curses
curst74931022curst
curve104920022curve
druse64817662druse
dulse65415042dulse
dure56341812dur_e
dures65635922dures
durst66125172durst
furs76735042furs_
furze176815812furze
fuse76429992fu_se
gorse65926812gorse
guise64717712guise
gurge75419782gurge
gursh94512332gursh
horse86132652horse
hurst85527192hurst
lure45142462lur_e
lures56138532lures
marse76231152marse
morse76032702morse
mure65941332mur_e
mures75937212mures
murre74821072murre
muse67136032mu_se
nursed74514662nursed
nurser64314502nurser
nurses63919352nurses
ourie54027292ourie
ours47237562ours_
parse75236992parse
perse75429522perse
pulse74219972pulse
pure65543332pur_e
puree74632842puree
purge85324602purge
purs65641042purs_
pursed95220882pursed
purser85020472purser
purses84826372purses
pursue84512252pursue
pursy105016412pursy
qursh174110842qursh
ruse45938932ru_se
sure45447412sur_e
surge65027692surge
terse55026822terse
torse55833332torse
urase54624682_urase
urge54722412_urge
ursa44116902_ursa
ursae55214452_ursae
use36835162_u_se
verse84723582verse
worse86525262worse
wurst85122992wurst

Search took 2 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 Filter178691538000.0931921408.6
2DLD Change Limit538002001.47036598.6
3Display Results2002000.0633174.6
 (SQL Overall)1786912001.626109896.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.