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

168 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
buret7744401(None) 
beret74946361beret
burets84321261burets
burnet84326171burnet
burnt75230321burnt
burst75332241burst
curet75447641curet
aurei54821862aurei
aures55137092aures
barbet104427882barbet
bare65460522bare_
bared85144482bared
barer74535802barer
bares75457132bares
barest85327692barest
barret84930482barret
beet66457542b_eet
befret11315962befret
beget85632552beget
bereft114317302bereft
berets85822522berets
beset76739132beset
bet58376672b__et
bidet84935622bidet
blet66247672b_let
bluet75631192bluet
blurt77625622blur_t
bore66051332bore_
bored85034302bored
borer75131272borer
bores76448252bores
bort65960962bor_t
brat66055542b_rat
bred75130972b_red
bree67241262b_ree
bren65629562b_ren
brent75734132b_rent
brew95023562b_rew
brit66350152b_rit
bruit76126722bruit
brunet84419292brunet
brunt75728752brunt
brut66537962b_rut
brute75321782brute
bucket144620732bucket
budget104618112budget
buffet143113782buffet
built74325922built
bullet84528612bullet
bundt85824852bundt
bunt65850852bu_nt
bur55744692bur__
bura66139532bur_a
buran75225302buran
buras74736292buras
burb85334672bur_b
burbot10815652burbot
burbs95423492burbs
burd75534262bur_d
burden9412472burden
burds84626062burds
bureau8712522bureau
burette939852burette
burg74930362bur_g
burgee97120592burgee
burger94020792burger
burgh115216032burgh
burgs84924092burgs
buried94822372buried
burier84324652burier
buries84633272buries
burin75626062burin
burka114617692burka
burke115122762burke
burked135220882burked
burker125221172burker
burkes124421312burkes
burl64937182bur_l
burled94825382burled
burler84723832burler
burley114715752burley
burls74228852burls
burly104922832burly
burn65636422bur_n
burned95818962burned
burner83819202burner
burnets93813262burnets
burns74926772burns
burp85028882bur_p
burped116215502burped
burps94220172burps
burqa165013092burqa
burr65631232bur_r
burred95820722burred
burrer83718472burrer
burro75018492burro
burrs74925652burrs
burry105221562burry
burs65847422bur_s
bursa74921522bursa
burse75527252burse
burses84425512burses
bursts85116242bursts
bury95633592bur_y
bused85624492bused
buses75936012buses
bust65947782bu_st
but55963022bu__t
bute66739672bute_
buteo75419892buteo
butes714535872butes
butt65143742bu_tt
butte74924292butte
butut75522912butut
buyer105013092buyer
byre95023852byre_
byres104421382byres
caret75360562caret
cruet74831842cruet
culet76040342culet
cure66149122cure_
cured85932132cured
curer75030752curer
cures75645432cures
curets84922342curets
curst74931022curst
curt67051712cur_t
curvet114720242curvet
duet56446262du_et
dure56341812dure_
dured75025402dured
dures65635922dures
durst66125172durst
duvet9321872duvet
egret63327312egret
fret75845042_fret
fumet105630222fumet
gurnet74920872gurnet
hurst85527192hurst
hurt77142572hur_t
jurat124829322jurat
jurel124516332jurel
lunet56835422lunet
lure45142462lure_
lured65427492lured
lurer54625312lurer
lures56138532lures
lurex124816732lurex
mure65941332mure_
mured85726702mured
mures75937212mures
murex145517172murex
pure65543332pure_
puree74632842puree
purer75127902purer
purest84021932purest
quiet144530732quiet
ret35982832__ret
suet46754822su_et
sure45447412sure_
surer54833092surer
surest65026762surest
surety93515002surety
tret46653532_tret
turret63121852turret
urea46528052_urea
wurst85122992wurst
yurt76435042yur_t

Search took 5 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.186960704.3
2DLD Change Limit538001683.75014346.7
3Display Results1681680.0931806.5
 (SQL Overall)1786911684.02944351.2
 
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.