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 “burghers” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

259 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
burghers143563(None) 
burgers103918571burg_ers
burgher1337001burgher_
brushers134210572brushers
budgers114314922budg_ers
buggers114315662bu_ggers
buglers105115322bu_glers
bulgers105215142bulg_ers
bulghurs1452762bulghurs
bunglers11398482bunglers
burblers12399262burblers
burgees104915892burg_ees
burger94020792burg_er_
burgess10409342burg_ess
burghs12519922burgh__s
burglars1154592burglars
burgles105615962burgle_s
buriers94017192bur_iers
burkers133716622bur_kers
burlers94120272bur_lers
burners94115672bur_ners
burrers93814492bur_rers
bursters1038982bursters
burthens1335382burthens
bushers124018802bu_shers
butchers153710182butchers
furthers1436492furthers
lurchers13307152lurchers
murthers1336542murthers
purgers104714002purg_ers
surgers83517482surg_ers
urgers73313622_urg_ers
archers124414573_archers
arguers8489023_arguers
augers73818703au_g_ers
badgers114812643badg_ers
baggers113915693b_aggers
bangers104020353bang_ers
barbers114317503bar_bers
bargees105415873barg_ees
barges94528253barg_e_s
barghest1447913barghest
barghests1543313barghests
barkers134318513bar_kers
barriers104311883barriers
barters94223033bar_ters
bashers124820833b_ashers
batchers153613273batchers
bathers124720363b_athers
belchers153510023belchers
benchers153611013benchers
bergere1068913berg_ere
bergeres1189103berg_eres
bingers104519983bing_ers
birches143412323birche_s
birders103913263bir_ders
birlers93813003bir_lers
blathers134713793blathers
blethers13429613blethers
blighters1555733blighters
blithers134711233blithers
bloggers12397403bloggers
bluchers15359033bluchers
bludgers12397853bludg_ers
blungers11469843blung_ers
blurters10348363blur_ters
blushers133911293blushers
bogglers12347603bogglers
boogers104514633boog_ers
borders104317533bor_ders
borers85122683bor__ers
botchers153511543botchers
bothers124317753b_others
bracers114616703b_racers
braggers12327903braggers
bravers124715523b_ravers
brayers124511903b_rayers
brazers184513943b_razers
brewers123811053b_rewers
bribers114111493b_ribers
briers85319733b_r_iers
briners94315633b_riners
brokers133111913b_rokers
brothers133410823brothers
brughs12509063brugh__s
bruisers10307953bruisers
bruiters10329133bruiters
brunchers16296253brunchers
brusher123813003brusher_
brushes124014663brushe_s
bubblers11448943bubblers
buckers153517453bu_ckers
bucklers16349503bucklers
budders113812103bu_dders
budger104617703budg_er_
budges104820123budg_e_s
budgeters1343593budgeters
budgets11489863budg_ets
budgies115312513budgie_s
buffers153310793bu_ffers
bugbears1333693bu_gbears
bugger104418723bu_gger_
buggery14367933bu_ggery
buggier113611343buggier_
buggies114613813buggie_s
bugler94717723bu_gler_
bugles94822443bu_gle_s
buhrs104811243bu__h_rs
builders1146743builders
bulger94917353bulg_er_
bulges95919323bulg_e_s
bulghur1352723bulghur_
bulgier103911213bulgier_
bulgurs10397113bulg_urs
bumblers143710733bumblers
bummers133712443bu_mmers
bumpers133912053bu_mpers
bunches144116033bunche_s
bundlers11399183bundlers
bungees104513103bung_ees
bungler104611483bungler_
bungles104116763bungle_s
bunkers133715953bu_nkers
bunters94717113bu_nters
burbler114412423burbler_
burbles114916803burble_s
burdeners1245063burdeners
burdens1039713bur_dens
burdies104117563burdie_s
burets84321263bur__ets
burgages1236483burgages
burgee97120593burg_e_e
burgeon1036433burg_eon
burgeons1146053burgeons
burgh115216033burgh___
burghal1335073burgh_al
burglar1065533burglar_
burglary1473133burglary
burgle94815863burgle__
burgled115511423burgle_d
burgonets1243513burgonets
burgoos1037123burg_oos
burgouts1145123burgouts
burgs84924093burg___s
burier84324653bur_ier_
buries84633273bur_ie_s
burker125221173bur_ker_
burkes124421313bur_ke_s
burler84723833bur_ler_
burleys12479673bur_leys
burlier93514413burlier_
burner83819203bur_ner_
burnets93813263bur_nets
burnies94017823burnie_s
burnishers1543693burnishers
burrer83718473bur_rer_
burrier93613543burrier_
burrowers1483493burrowers
burrs74925653bur___rs
bursars94510893bur_sars
burseeds1134783burseeds
bursera936763bur_sera
burses84425513bur_se_s
burster9310293burster_
burthen1236363burthe_n
burweeds1434103burweeds
bushels124110713bu_shels
busher114922203bu_sher_
bushes115226113bu_she_s
buskers133414083bu_skers
busters94724123bu_sters
bustiers103810043bustiers
bustlers104210613bustlers
butcher143411163butcher_
butchery18326253butchery
butches144315363butche_s
butlers94518053bu_tlers
butters94521713bu_tters
buyers114511003bu__yers
buzzers17347173bu_zzers
coughers14399953coughers
crushers134010083crushers
curbers115514373cur_bers
curches143512743curche_s
curdlers11368493curdlers
curers84923183cur__ers
curlers94218063cur_lers
curriers103410753curriers
cursers94317153cur_sers
druthers1275793druthers
forgers115218183forg_ers
forgoers1236413forgoers
furlers104214223fur_lers
furriers11369483furriers
further1337003further_
garglers10418263garglers
gorgers94813643gorg_ers
gurges84716863gurg_e_s
gurgles94312873gurgle_s
gurglets10355543gurglets
gurshes112210033gurshe_s
gushers113512503gu_shers
huggers124211593hu_ggers
hungers114013303hung_ers
hurdlers12337493hurdlers
hurlers103714323hur_lers
hurriers11358893hurriers
hurters103413633hur_ters
judgers16369043judg_ers
jugglers17366523jugglers
laughers1235923laughers
lugers74617023lu_g_ers
luggers93713483lu_ggers
lunchers13349563lunchers
lungers83817083lung_ers
lurcher12338133lurcher_
lurches123311663lurche_s
lurers64217493lur__ers
lurkers113910083lur_kers
marchers153710813marchers
mergers103813423merg_ers
muggers113611933mu_ggers
munchers15318773munchers
murders103311363mur_ders
murther1237953murther_
mushers124016433mu_shers
northers1139333northers
nudgers9479373nudg_ers
nursers74311833nur_sers
perchers153611523perchers
punchers152610073punchers
purflers13216963purflers
purger94717233purg_er_
purges94421763purg_e_s
pursers93916093pur_sers
pursuers10376523pursuers
pushers123814503pu_shers
quashers20186803quashers
qurshes19228573qurshe_s
roughers12329173roughers
ruggers94612313ru_ggers
rushers103816103ru_shers
sergers83815633serg_ers
sighers113712173_sighers
surfers103614133sur_fers
surger74320093surg_er_
surgery11319203surg_ery
surges73924593surg_e_s
tuggers93711443tu_ggers
turgors836823turg_ors
turners73912893tur_ners
turtlers8258203turtlers
ureters7311823_ureters
urger64116473_urg_er_
urges64619913_urg_e_s
ushers94415533_u_shers
vergers114412623verg_ers
weighers15135673weighers
wuthers133711523wu_thers

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461622597.56019333.6
3Display Results2592590.1102354.5
 (SQL Overall)1786912597.82622833.0
 
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.