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

108 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
burgout104977(None) 
bugout9311861bu_gout
burgouts1145121burgouts
burnout9310451burnout
bugouts1036192bu_gouts
burbot10815652burbo_t
burgonet1148102burgonet
burgoo938932burgo_o
burgoos1037122burgoos
burnous938822burnous
burnouts1045262burnouts
buyout11310102bu_yout
dugout8310362du_gout
surtout7411682surtout
turnout7410282turnout
argot67728653_argo_t
aurous64119263aur_ous
backout15612953backout
bailout9414133bailout
barbut104617003bar_but
begot84625953b_ego_t
beshout12311843beshout
bigot84828323b_igo_t
blowout1248403blowout
bout66353293b___out
brogue94211033b_rogue
brulot8912213brulo_t
brumous11107443brumous
brut66537963b_r__ut
budget104618123budg_et
bulbous1138293bulbous
bulghur1352723bulghur
bulgur9387533bulg_ur
bullous9311663bullous
bullpout1245783bullpout
bumboat1349023bumboat
burbots1168673burbots
burdock1644603burdock
bureau8712523bureau_
bureaus979293bureaus
bureaux1664593bureaux
buret77444013bur__et
burg74930363burg___
burgage1136633burgage
burgee97120593burg_ee
burgees104915893burgees
burgeon1036433burgeon
burgeons1146053burgeons
burger94020793burg_er
burgers103918573burgers
burgess10409343burgess
burgh115216033burg__h
burghal1335073burghal
burgher1337003burgher
burghs12519923burg_hs
burglar1065533burglar
burgle94815863burg_le
burgled115511423burgled
burgles105615963burgles
burgonets1243513burgonets
burgs84924093burg__s
burnet84326173bur_net
burnt75230333bur__nt
burro75018493burro__
burros85114993burro_s
burrow114610803burro_w
burrows12399093burrows
burst75332243bur__st
burton8311273burto_n
burtons9310853burtons
bushgoat1443443bushgoat
butut75522913bu__tut
buyouts1235203bu_youts
buzzcut1942473buzzcut
curious93813563curious
cutout8315923cu_tout
dugouts935043du_gouts
ergot65422893_ergo_t
forgot104318133forgo_t
fungous11367433fungous
furious103110633furious
gout56646003___gout
grout65330423_gr_out
gurglet94412033gurglet
hangout11411393hangout
pigout9314613_pigout
pullout9310593pullout
purport1159393purport
putout8315113pu_tout
ragout7317183_ragout
rout46153283__r_out
rubout8313563ru_bout
rugous739653ru_gous
runout6414873ru_nout
sprout8419403spr_out
surcoat9412923surcoat
surmount1045903surmount
surtouts846203surtouts
trout57332573_tr_out
tryout9410763_tryout
turbot8914263turbo_t
turgent8712393turgent
turgor736863turgo_r
turgors836833turgors
turnouts845413turnouts
ungot61718063_ungo_t
urgent73816043_urgent
workout1448393workout

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 Filter1786911340270.423422437.4
2DLD Change Limit1340271086.95319276.1
3Display Results1081080.0303600.0
 (SQL Overall)1786911087.40624127.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.