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 “estrange” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

95 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
estrange948889(None) 
estranged11387661estranged
estranger10447841estranger
estranges10359981estranges
strange85416341_strange
astringe938222astringe
entrance10311332entrance
estrangers11376112estrangers
estrone7413952estron_e
outrange92410222outrange
strang75718312_strang_
stranger94715102_stranger
stranges94516762_stranges
strangle98411502_strangle
arrange838683_arrange
astringed1145693astringed
astringes1038343astringes
derange939813_derange
embrangle1453293embrangle
enrage72715073e_nra_ge
entangle966253ent_angle
entranced1247393entranced
entrances11310953entrances
entrant7318873entran_t
entrants8311753entrants
escuage1035113escua_ge
eserine7415903eserin_e
esperance1346693esperance
estate64719763est_a_te
esterase849483estera_se
estragon944793estragon
estral64716513estra__l
estranging1246023estranging
estray95713333estra__y
estrayed1236393estrayed
estraying1338293estraying_
estrays10529403estra_ys
estrin6315923estrin__
estrins7315853estrin_s
estrogen946573estr_ogen
estrones8313333estrones
ethane94613243e_than_e
exchange21124323exchange
extranet15412993extranet
grange83716203__grange
mestranol1143893mestranol
midrange1244433midrange
oestrone849973oestron_e
orange74016323__orange
outrage82616893outra_ge
outrance102212783outrance
outrang83813953outrang_
outranged11239043outranged
outranges102510013outranges
range64728423___range
rearrange1045043rearrange
resprang11175843resprang_
restage83316193rest_a_ge
restring91518783restring_
restrings10159293restrings
restrung9176443restrung_
sprang95713523_sprang_
sprangs104610053_sprangs
springe103913983_springe
stage65330193_st_a_ge
stance84316913_st_ance
stane55933003_st_an_e
stang66424693_st_ang_
stanged94113853_st_anged
stangs75018173_st_angs
storage8310473_stora_ge
strafe95215983_stra_fe
straggle10359133_straggle
strake104017393_stra_ke
strand74514823_stran_d
stranded102710813_stranded
strander97112063_strander
strands83711953_strands
strangely1345413_strangely
strangers104112173_strangers
strangest103210843_strangest
strangled11268983_strangled
strangler10369473_strangler
strangles103011563_strangles
stravage1245563_stravage
string75327563_string_
stringed102911873_stringed
stringer93812943_stringer
strings84617133_strings
stringy114111073_stringy
strong74914883_strong_
stronger9349703_stronger
strung75213023_strung_
syringe11349473_syringe
trance84718763__trance

Search took 9 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.423422437.4
2DLD Change Limit146162958.20317818.1
3Display Results95950.0303166.7
 (SQL Overall)178691958.65620643.6
 
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.