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

126 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
burgers10391857(None) 
budgers114314921budgers
buggers114315661buggers
bulgers105215141bulgers
burgees104915891burgees
burger94020791burger_
burgess10409341burgess
burghers1435631burghers
buriers94017191buriers
burkers133716621burkers
burlers94120271burlers
burners94115671burners
burrers93814491burrers
purgers104714001purgers
surgers83517481surgers
urgers73313621_urgers
augers73818702au_gers
badgers114812642badgers
baggers113915692baggers
bangers104020352bangers
barbers114317502barbers
bargees105415872bargees
barges94528252barge_s
barkers134318512barkers
barters94223032barters
bergere1068912bergere
bergeres1189102bergeres
bingers104519992bingers
birders103913262birders
birlers93813002birlers
bludgers12397852bludgers
blungers11469842blungers
blurters10348362blurters
boogers104514632boogers
borders104317532borders
borers85122682bor_ers
briers85319732b_riers
buckers153517452buckers
budders113812102budders
budger104617702budger_
budges104820122budge_s
budgets11489862budgets
buffers153310792buffers
bugger104418722bugger_
buggery14367932buggery
buglers105115322buglers
bulger94917352bulger_
bulges95919322bulge_s
bulgurs10397112bulgurs
bummers133712442bummers
bumpers133912052bumpers
bungees104513102bungees
bunglers11398482bunglers
bunkers133715952bunkers
bunters94717112bunters
burblers12399262burblers
burdens1039712burdens
burets84321262bur_ets
burgee97120592burge_e
burgeon1036432burgeon
burgeons1146052burgeons
burgher1337002burgher_
burghs12519922burg_hs
burglars1154592burglars
burgles105615962burgles
burgoos1037122burgoos
burgs84924092burg__s
burier84324652burier_
buries84633272burie_s
burker125221172burker_
burkes124421312burke_s
burler84723832burler_
burleys12479672burleys
burner83819202burner_
burnets93813262burnets
burrer83718472burrer_
burrs74925652bur__rs
bursars94510892bursars
bursera936762bursera
burses84425512burse_s
bursters1038982bursters
bushers124018802bushers
buskers133414082buskers
busters94724122busters
butlers94518052butlers
butters94521712butters
buyers114511002bu_yers
buzzers17347172buzzers
curbers115514372curbers
curers84923182cur_ers
curlers94218062curlers
cursers94317152cursers
forgers115218182forgers
furlers104214222furlers
gorgers94813642gorgers
gurges84716862gurge_s
huggers124211592huggers
hungers114013302hungers
hurlers103714322hurlers
hurters103413632hurters
judgers16369042judgers
lugers74617022lu_gers
luggers93713482luggers
lungers83817092lungers
lurers64217492lur_ers
lurkers113910082lurkers
mergers103813422mergers
muggers113611932muggers
murders103311362murders
nudgers9479372nudgers
nursers74311832nursers
purger94717232purger_
purges94421762purge_s
pursers93916092pursers
ruggers94612312ruggers
sergers83815632sergers
surfers103614132surfers
surger74320092surger_
surgery11319202surgery
surges73924592surge_s
tuggers93711442tuggers
turgors836822turgors
turners73912892turners
urger64116472_urger_
urges64619912_urge_s
vergers114412622vergers

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 Filter1786911076710.1401276364.3
2DLD Change Limit1076711263.81328237.9
3Display Results1261260.0462739.1
 (SQL Overall)1786911263.99944683.9
 
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.