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

272 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
burgoo93893(None) 
burgoos1037121burgoos
broo65129822b_r_oo
burbot10815652burbot
burg74930362burg__
burgee97120592burgee
burgeon1036432burgeon
burger94020792burger
burgh115216032burg_h
burghs12519922burghs
burgle94815862burgle
burgout1049772burgout
burgs84924092burg_s
burro75018492bur_ro
burros85114992burros
burrow114610802burrow
burton8311272burton
turgor736862turgor
argol65317263_argol
argon65520593_argon
argot67728643_argot
baboo94319503b_aboo
bamboo12310013bamboo
barge85631023barg_e
barged105822643barged
bargee94624443bargee
barges94528253barges
barhop13319643barhop
barlow112911423barlow
baron78131243bar_on
barrio8312573barrio
barroom1139373barroom
barrow114512763barrow
baryon111211613baryon
bazoo163815673b_azoo
begot84625953b_egot
berg75425543berg__
bergs84718043berg_s
bigos85020013b_igos
bigot84828323b_igot
bingo86020093bing_o
bingos95514793bingos
biro66131213bir__o
biros75325133bir_os
bongo85720943bong_o
bongos95316653bongos
boo58163663b___oo
booboo1039463booboo
boocoo1039003boocoo
boohoo1148833boohoo
bookoo1248343bookoo
boron76727143bor_on
borrow114310723borrow
borzoi1736623borzoi
bourbon1135813bourbon
bourdon1036423bourdon
bourg84113843bourg__
bourgeon1144683bourgeon
bourgs9459993bourg_s
bravo105214343b_ravo
brio65432493b_r_io
brios74725723b_rios
bro56236603b_r__o
bromo95217203b_romo
brood84620243b_rood
brook114717763b_rook
broom95022213b_room
broos75126413b_roos
bros65635663b_r_os
brow97228443b_r_ow
brugh115414293brug_h
brughs12509063brughs
brulot8912213brulot
bubo85621913bu__bo
bucko134614023bu_cko
buckos143710893buckos
budge94619873budg_e
budged114517233budged
budger104617703budger
budges104820123budges
budget104618113budget
budgie104310343budgie
buffo135112183bu_ffo
buffoon1543713buffoon
buffos14447853buffos
bug65340743bu_g__
bugaboo1244313bugaboo
bugged114318403bugged
bugger104418723bugger
buggy124613483bu_ggy
bugle84721943bu_gle
bugout9311863bu_gout
bugs76035913bu_g_s
bulge86419873bulg_e
bulged105117123bulged
bulger94917353bulger
bulges95919323bulges
bulgur9387533bulgur
bulgy115214103bulg_y
bunco94616083bu_nco
buncos104011593buncos
bung75730633bung__
bunged105218793bunged
bungee96319773bungee
bungle97116113bungle
bungs85323863bung_s
bunion83111313bunion
bunko115514513bu_nko
bunkos124210323bunkos
buoy95921783bu__oy
bur55744693bur___
bura66139533bur__a
buran75225303bur_an
burans85019303burans
buras74736293bur_as
burb85334673bur__b
burble104617703burble
burbly134311153burbly
burbots1168673burbots
burbs95423493bur_bs
burd75534263bur__d
burden9412473burden
burdie93615023burdie
burdock1644603burdock
burds84626063bur_ds
bureau8712523bureau
buret77444013bur_et
burets84321263burets
burgage1136633burgage
burgees104915893burgees
burgeons1146053burgeons
burgers103918573burgers
burgess10409343burgess
burghal1335073burghal
burgher1337003burgher
burglar1065533burglar
burgled115511423burgled
burgles105615963burgles
burgonet1148103burgonet
burgouts1145123burgouts
burial84117623burial
buried94822373buried
burier84324653burier
buries84633273buries
burin75626063bur_in
burins84221893burins
burka114617693bur_ka
burkas124513803burkas
burke115122763bur_ke
burked135220883burked
burker125221173burker
burkes124421313burkes
burl64937183bur__l
burlap1098353burlap
burled94825383burled
burler84723833burler
burley114715753burley
burls74228853bur_ls
burly104922833bur_ly
burn65636423bur__n
burned95818963burned
burner83819203burner
burnet84326173burnet
burnie83715413burnie
burnoose1043313burnoose
burnous938823burnous
burnout9310453burnout
burns74926773bur_ns
burnt75230323bur_nt
burp85028883bur__p
burped116215503burped
burps94220173bur_ps
burqa165013093bur_qa
burqas174410903burqas
burr65631233bur__r
burred95820723burred
burrer83718473burrer
burrito936223burrito
burrows12399093burrows
burrs74925653bur_rs
burry105221563bur_ry
burs65847423bur__s
bursa74921523bur_sa
bursae84515603bursae
bursal84414823bursal
bursar85413253bursar
bursas85318273bursas
burse75527253bur_se
burses84425513burses
burst75332243bur_st
bursts85116243bursts
burtons9310853burtons
bury95633593bur__y
busboy13307443busboy
buteo75419893bu_teo
buteos84913413buteos
button8310273button
buxom1647153bu_xom
cargo85322073carg_o
cargos94619183cargos
cuckoo1486413cuckoo
curio74221203cur_io
curios83218333curios
cursor84110293cursor
durion7510963durion
duro56228023dur__o
duroc84513143dur_oc
duros65422693dur_os
ergo56420153_erg_o
ergot65422893_ergot
erugo6369853erug_o
erugos7347343erugos
euro45325273eur__o
euros54920243eur_os
forgo94418333forg_o
forgot104318133forgot
fourgon1134863fourgon
fugio9310923fu_gio
fungo94413133fung_o
furioso1044323furioso
furor8312393fur_or
furrow12427743furrow
goo47754773___goo
gorgon8310243gorgon
gurge75419783gurg_e
gurged95513363gurged
gurges84716863gurges
gurgle83912473gurgle
hulloo94511733hulloo
jargon1448823jargon
jargoon1545193jargoon
juror1239563jur_or
karoo92519583kar_oo
karroo10410013karroo
kurgan11126783kurgan
largo65319783larg_o
largos74815063largos
mungo84916053mung_o
mungos94311373mungos
outgo6312093outg_o
pargo86723723parg_o
pargos95719043pargos
purge85324603purg_e
purged104918263purged
purger94717233purger
purges94421763purges
sargo65424413sarg_o
sargos74318273sargos
sorgho10348713sorgho
sorgo64719723sorg_o
sorgos74514663sorgos
surge65027693surg_e
surged84118883surged
surgeon837003surgeon
surger74320093surger
surges73924593surges
surgy95118523surg_y
turaco839453turaco
turbo71015043tur_bo
turbos8910783turbos
turbot8914263turbot
turgid868013turgid
turgors836823turgors
turion6313163turion
turnon638193turnon
ungot61718063_ungot
uredo65112993_uredo
urge54722413_urg_e
urged75316033_urged
urger64116473_urger
urges64619913_urges
vulgo936953vulg_o

Search took 7 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 Filter1786911127160.1401276364.3
2DLD Change Limit1127162725.72019705.6
3Display Results2722720.1401942.9
 (SQL Overall)1786912726.00029781.8
 
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.