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

105 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
burnout931045(None) 
burgout1049771burgout
burnous938821burnous
burnouts1045261burnouts
turnout7410281turnout
bugout9311862bu_gout
burbot10815652burbo_t
burgouts1145122burgouts
burnet84326172burn_et
burnt75230332burn__t
buyout11310102bu_yout
runout6414872ru_nout
surtout7411672surtout
turnouts845412turnouts
alburnous1143083alburnous
aurous64119263aur_ous
backout15612953backout
bailout9414133bailout
barbut104617003bar_but
baronet91022203baronet
beknot1239763bekno_t
beshout12311833beshout
blowout1248403blowout
bout66353293b___out
brownout1345683brownout
brulot8912213brulo_t
brumous11107443brumous
brunet84419293brun_et
brunt75728753brun__t
brut66537963b_r__ut
bugouts1036193bu_gouts
bulbous1138293bulbous
bullous9311663bullous
bullpout1245783bullpout
bumboat1349023bumboat
bundt85824853bu_n_dt
bunkum1435983bu_nkum
bunt65850853bu_n__t
burbots1168673burbots
burdock1644603burdock
bureau8712523bureau_
bureaus979293bureaus
bureaux1664593bureaux
buret77444013bur__et
burgonet1148103burgonet
burgoo938933burgo_o
burgoos1037123burgoos
burn65636433burn___
burned95818963burn_ed
burner83819203burn_er
burners94115673burners
burnets93813263burnets
burnie83715413burn_ie
burnies94017823burnies
burning104215503burning
burnish1238623burnish
burnoose1043313burnoose
burnouses1144853burnouses
burns74926783burn__s
burro75018493burro__
burros85114993burro_s
burrow114610803burro_w
burrows12399093burrows
burst75332243bur__st
burton8311273burto_n
burtons9310853burtons
butut75522913bu__tut
buyouts1235203bu_youts
buzzcut1942473buzzcut
curious93813563curious
cutout8315923cu_tout
dugout8310363du_gout
furious103110633furious
grout65330423_gr_out
gurnet74920873gurn_et
hornpout1356703hornpout
knout95018263__knout
pullout9310593pullout
purport1159393purport
putout8315113pu_tout
rainout7314393rainout
rout46153283__r_out
rubout8313563ru_bout
ruinous739763ruinous
runouts737353ru_nouts
snout54530633__snout
spinout9311583spinout
sprout8419403spr_out
surcoat9412923surcoat
surmount1045903surmount
surtouts846203surtouts
trout57332573_tr_out
tryout9410753_tryout
turbot8914263turbo_t
turnabout1153753turnabout
turncoat1044853turncoat
turnoff1344013turnoff
turnon638193turno_n
turnons737863turnons
turnup835093turn_up
uncut73219173_u_ncut
unroot6315553_unroot
uranous7310733_uranous
urinous7310083_urinous
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 Limit1340271057.25018486.5
3Display Results1051050.0462282.6
 (SQL Overall)1786911057.71923149.5
 
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.