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

102 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
outburns103606(None) 
outburn936901outburn_
outburnt1057151outburnt
outturns835911outturns
auburns935572au_burns
outbarks1437832outbarks
outbulks1444762outbulks
outburned1245212outburned
outburst1046842outburst
outbursts1143692outbursts
outbuys1246052outbu_ys
outearns838402outearns
outguns8318692outgu_ns
outruns72911542outru_ns
outturn737122outturn_
sunburns1044282sunburns
auburn836213au_burn_
auteurs7137513auteur_s
autumns943763aut_umns
burns74926783___burns
cothurns1344523cothurns
coutures10311993cout_ures
futures10310263fut_ures
inturns73210133int_urns
lutherns1136293lutherns
nocturns1043733noct_urns
ouabains1044363ouabains
outbacks1638983outbacks
outbakes1439993outbakes
outbark1339453outbar_k
outbawls1336053outbawls
outbeams1236063outbeams
outbegs1036483outb_egs
outbids1098913outb_ids
outbless1037963outbless
outbluffs1741393outbluffs
outboards1246213outboards
outbound1146583outbound
outboxes1737823outboxes
outbrag1036993outb_rag
outbrags1136693outbrags
outbred10311263outb_red
outbuild1144843outbuild
outbuilds1243113outbuilds
outbuilt1046873outbuilt
outbulge11134753outbulge
outbulges12134743outbulges
outbulk1336003outbu_lk
outbully1345103outbully
outburning1345093outburning
outbuy1146943outbu__y
outbuying1545563outbuying
outcurse1045833outcurse
outcurses1145803outcurses
outcurve1344433outcurve
outcurves1444563outcurves
outdares92712463outdares
outdrunk1343473outdrunk
outduels945053outduels
outearn7310683outearn_
outers64230173out_er_s
outfawns1434723outfawns
outfires1139863outfires
outgains9810163outgains
outgrins979823outgrins
outguess944983outguess
outgun7349643outgu_n_
outhunt10311043outhu_nt
outhunts1136033outhunts
outjumps1942603outjumps
outjuts1476493outju_ts
outlearns944633outlearns
outmans92413283out_mans
outplans10259533outplans
outports1048273outports
outpours1036683outpour_s
outpulls1065443outpulls
outputs988493outpu_ts
outrun63213303outru_n_
outrung8349573outru_ng
outscorns11144883outscorns
outserts8309803outserts
outsins73417863out_sins
outspans1038223outspans
outsulks1244993outsulks
outsung8348153outsu_ng
outwards1299123outwards
outwars10912793outwar_s
outworks15148973outworks
outworn101610753outworn_
overburns14135613overburns
postburn1243923postburn_
returns79712593ret_urns
southerns12347213southerns
suborns939493su_borns
suburbs1136503su_burbs
sunburn945133sunburn_
sunburnt1045603sunburnt
sutures7314223sut_ures
turns55623243__t_urns
unburnt977413_unburnt
upturns9264973_upturns

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.406440125.6
2DLD Change Limit1461621026.87321266.1
3Display Results1021020.0462217.4
 (SQL Overall)1786911027.32524394.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.