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

129 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
auburns93557(None) 
auburn836211auburn_
augurs7399962augur_s
autumns943762autumns
burns74926782__burns
outburns1036062outburns
suborns939492suborns
suburbs1136502suburbs
sunburns1044282sunburns
abjures1636523abjures
ablins8316193a_blins
aborts84916183a_borts
abris75722603a_b_ris
absurds1035003absurds
abuses85119103a_buses
abuts75417073a_bu_ts
acorns85013013a_corns
adjourns1662863adjourns
adjures1536233adjures
adorns74212613a_dorns
aiblins9311473aiblins
airns55521033a__irns
albumens1244143albumens
albumins1245353albumins
albums10198273albu_ms
alburnous1143083alburnous
alburnum12112863alburnum
alburnums1372013alburnums
aleurons867013aleurons
allures72913113allures
ambaris113112163ambaris
ambers104519583amber_s
amours83512663amour_s
aneurins849073aneurins
anurans73810553a_nurans
arbores94016033arbores
arbors84717883arbor_s
arbours93910043arbour_s
arbutes939703arbutes
arbutus944843arbutus
armures9510273armures
assures7611403assures
attorns738443attorns
aubades1038753aubades
auberge1045633auberge
auberges1146673auberges
aucubas1145173aucubas
augers73818703auger_s
augur64311213augur__
augural856403augural
augured987193augured
augurer8136343augurer
augurers9114813augurers
auguries947933auguries
auguring1036383auguring
augury10366663augur_y
auras55932563a__uras
aures55137093a__ures
auris55331533a__uris
auroras7311703auroras
aurums849383auru_ms
ausubos942943ausubos
auteurs7137503auteur_s
autumn836013autumn_
auxins13129813au_xins
azures15510183a_zures
barns76335143__barns
bourns84114063_bourns
bubus95115453bubu__s
bunns74718293__bunns
buns66243723__bu_ns
burans85019303__burans
buras74736303__buras
burbs95423493__burbs
burds84626063__burds
burgs84924093__burgs
burins84221893__burins
burls74228853__burls
burn65636433__burn_
burnt75230333__burnt
burps94220173__burps
burrs74925653__burrs
burs65847423__bur_s
carbarns1238563carbarns
churns114910233_churns
cubers105318353cuber_s
curns74924283__curns
daubers104610423dauber_s
dubbins12358803dubbins
durns64819873__durns
faubourgs1541233faubourgs
futures10310263futures
hamburgs1643473hamburgs
hauberks1742993hauberks
hubris11218973hub_ris
inturns73210133inturns
inurns63310983_inurns
lucerns935753lucerns
mourns84111013_mourns
nubbins11268023nubbins
nubucks1544003nubucks
outburn936903outburn_
outburnt1057153outburnt
outruns72911543outruns
outturns835913outturns
querns15307943qu_erns
returns79712593returns
rubus76415063rubu__s
samburs11369343sambur_s
spurns84811383_spurns
suberins10315093suberins
subers85722643suber_s
suborn8310013suborn_
suburb1037163subur_b
suburbans1344093suburbans
sunburn945133sunburn_
sunburnt1045603sunburnt
sutures7314223sutures
tabuns8489223tabu_ns
tamburas12316053tamburas
tamburs11288613tambur_s
tubers85017033tuber_s
tubules9310233tubules
tubulins10106293tubulins
turns55623243__turns
unburnt977413unburnt
upturns9264973upturns
urns46323903___urns
usurps8105073_usurps

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 Filter1786911340270.423422437.4
2DLD Change Limit1340271296.15621771.8
3Display Results1291290.0304300.0
 (SQL Overall)1786911296.60927037.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.