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

163 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
burkes12442131(None) 
bubkes144612621bubkes
bupkes144811481bupkes
buries84633271buries
burkas124513801burkas
burke115122761burke_
burked135220881burked
burker125221171burker
burkers133716621burkers
burses84425511burses
aures55137092aur_es
bakes117035372b_akes
barbes104526232barbes
bardes95026932bardes
bares75457132bar_es
barges94528252barges
barked135027312barked
barker124822862barker
barkers134318512barkers
barks115735812bark_s
barres84427552barres
baryes116218502baryes
berakes134815772berakes
berks115423122berk_s
bermes106023002bermes
bikes117529472b_ikes
birkies133712432birkies
birks114920302birk_s
birles84920642birles
birses84717732birses
blokes123813882blokes
bores76448252bor_es
borked135117292borked
borks115727702bork_s
bournes93615022bournes
bourses94014302bourses
braes75735052b_raes
brakes124923122brakes
brees75632552b_rees
bries74942152b_ries
brumes106417072brumes
brutes86118682brutes
bruxes154811022bruxes
buboes104513992buboes
bucked155121062bucked
bucker145420462bucker
buckers153517452buckers
bucket144620732bucket
buckets153811692buckets
buckles153416092buckles
buckoes153810392buckoes
buckos143710892buckos
bucks134824292buck_s
budges104820132budges
bugles94822442bugles
bulges95919322bulges
bulked134216742bulked
bulks115920612bulk_s
bunked135118372bunked
bunker124519372bunker
bunkers133715952bunkers
bunkos124210322bunkos
bunks115125082bunk_s
bupkus14385682bupkus
burans85019302burans
buras74736302bur_as
burbles114916802burbles
burbs95423492bur_bs
burden9412472burden
burdens1039712burdens
burdies104117562burdies
burds84626062bur_ds
buret77444012bur_et
burets84321262burets
burgee97120592burgee
burgees104915892burgees
burger94020792burger
burgers103918572burgers
burgess10409342burgess
burghs12519922burghs
burgles105615962burgles
burgs84924092bur_gs
buried94822372buried
burier84324652burier
buriers94017192buriers
burins84221892burins
burka114617692burk_a
burkites1436672burkites
burled94825382burled
burler84723832burler
burlers94120272burlers
burlesk1335462burlesk
burley114715752burley
burleys12479672burleys
burls74228852bur_ls
burned95818962burned
burner83819202burner
burners94115672burners
burnet84326172burnet
burnets93813262burnets
burnies94017822burnies
burns74926782bur_ns
burped116215502burped
burps94220172bur_ps
burqas174410902burqas
burred95820722burred
burrer83718472burrer
burrers93814492burrers
burros85114992burros
burrs74925652bur_rs
burs65847422bur__s
bursas85318272bursas
burse75527252burse_
bursts85116242bursts
buses75936012bu_ses
bushes115226112bushes
busies85525262busies
busked134917702busked
busker125517832busker
buskers133414092buskers
busks115521372busk_s
busses85023382busses
butes714535872bu_tes
butles84423912butles
buttes84822562buttes
buzzes165011172buzzes
byres104421382byr_es
cukes115422092cu_kes
cures75645432cur_es
curies84934022curies
curses85328272curses
curves114619282curves
dukes105023472du_kes
dures65635922dur_es
furies95126372furies
furzes186613692furzes
gurges84716862gurges
jukes165319102ju_kes
juries134120632juries
lures56138532lur_es
lurked114511972lurked
lurker103613292lurker
lurkers113910082lurkers
lurks95218742lurk_s
mures75937222mur_es
murker123715242murker
murkest133110202murkest
murks114821732murk_s
murres85019042murres
nukes95418122nu_kes
nurses63919352nurses
pukes114523022pu_kes
purees84721682purees
purges94421762purges
purses84826372purses
quakes194013342quakes
surges73924592surges
turkey1337762turkey
turkeys1434522turkeys
turks95320822turk_s
turves94212692turves
ukes86122812_u_kes
urges64619912_urges

Search took 8 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.593301333.9
2DLD Change Limit825511637.04611716.0
3Display Results1631630.0463543.5
 (SQL Overall)1786911637.68523251.9
 
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.