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

125 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
burets8432126(None) 
berets85822521berets
buret77444011buret_
burnets93813261burnets
bursts85116241bursts
curets84922341curets
aures55137092aure_s
aureus65314882aureus
barbets114915842barbets
bares75457132bare_s
barest85327692barest
barrets94917102barrets
beets76131442b_eets
befrets1237612befrets
begets96215522begets
beret74946362beret_
besets85718802besets
bets67051442b__ets
bidets95215532bidets
blets75324942b_lets
bluets87215492bluets
blurts84412642blur_ts
boreas85421732boreas
borers85122682borers
bores76448252bore_s
borts76735452bor_ts
brats75336012b_rats
brees75632552b_rees
brens75823362b_rens
brents84717272b_rents
brews105617072b_rews
brits76433082b_rits
bruits85714452bruits
brunets9419552brunets
brunts85215452brunts
brutes86118682brutes
bruts75922952b_ruts
buckets153811692buckets
budgets11489862budgets
buffets15317592buffets
bullets93516392bullets
bundts95010842bundts
bunts75729802bu_nts
burans85019302burans
buras74736302bur_as
burbots1168672burbots
burbs95423492bur_bs
burdens1039712burdens
burds84626062bur_ds
bureau8712522bureau
bureaus979292bureaus
burette939852burette
burettes1048952burettes
burgees104915892burgees
burgers103918572burgers
burgess10409342burgess
burghs12519922burghs
burgs84924092bur_gs
buriers94017192buriers
buries84633272buries
burins84221892burins
burkas124513802burkas
burkers133716622burkers
burkes124421312burkes
burlers94120272burlers
burleys12479672burleys
burls74228852bur_ls
burners94115672burners
burnet84326172burnet_
burns74926782bur_ns
burnt75230332burnt_
burps94220172bur_ps
burqas174410902burqas
burrers93814492burrers
burros85114992burros
burrs74925652bur_rs
burs65847422bur__s
bursas85318272bursas
burses84425512burses
burst75332242burst_
buses75936012buse_s
busts75227692bu_sts
buteos84913412buteos
butes714535872bute_s
buts67247692bu__ts
buttes84822562buttes
butts75824252bu_tts
bututs8409422bututs
buyers114511002buyers
byres104421382byre_s
carets85330772carets
cruets85314952cruets
culets85518512culets
curers84923192curers
cures75645432cure_s
curet75447642curet_
curvets12399912curvets
duets65323882du_ets
dures65635922dure_s
duress74712062duress
duvets1039222duvets
egrets72712242egrets
frets85523402_frets
fumets114311812fumets
gurnets84010792gurnets
hursts97213092hursts
hurts86922822hur_ts
jurats134213202jurats
jurels133710582jurels
lunets66914762lunets
lurers64217492lurers
lures56138532lure_s
mures75937222mure_s
purees84721682purees
purest84021932purest
quiets154014372quiets
rets45352562__rets
suets55126102su_ets
surest65026762surest
surety93515012surety
trets55928022_trets
turrets73010672turrets
ureas55826012_ureas
wursts95211162wursts
yurts87216532yur_ts

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.326548131.9
2DLD Change Limit825511252.48333246.5
3Display Results1251250.0462717.4
 (SQL Overall)1786911252.85562588.8
 
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.