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

151 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
astringe93822(None) 
astringed1145691astringed
astringes1038331astringes
astride8311972astri_de
astringent1145902astringent
estrange9488892estrange
springe103913982_springe
strange85416342_strange
string75327562_string_
stringed102911872_stringed
stringer93812942_stringer
strings84617132_strings
stringy114111072_stringy
syringe11349472_syringe
abridge1135693a_bridge
acarine9316003acarin_e
acting95920983act_ing_
actings104512463act_ings
adoring9412523adoring_
airing74927503a_iring_
airings83913833a_irings
airting83616303airting_
altering91917113altering_
anserine8313083anserin_e
anteing8312813anteing_
anting75827023ant_ing_
antings85015583ant_ings
arrange838683a_rrange
ascribe1147743ascri_be
ashing107824093as_hing_
asinine7310723asinin_e
asking116017233as_king_
askings12519173as_kings
aspiring1138873aspiring_
assuring937773assuring_
astatine8313533astatin_e
astilbe945653ast_ilbe
astrict9614783astri_ct
astricted1247433astricted
astricts1049453astricts
astringency1752083astringency
astringents1253913astringents
astringing1245773astringing
atingle848253a_t_ingle
attiring939483attiring_
attrite7311833attri_te
autoing8314043autoing_
basting104227203bast_ing_
bastings114214693bast_ings
befringe1484513befringe
cartridge1372723cartridge
casting104628343cast_ing_
castings113614053cast_ings
castling11311233castling_
citrine92514023citrin_e
constringe1345833constringe
cringe93515483__cringe
easting84924303east_ing_
eastings93412953east_ings
eserine7415903eserin_e
estranged11387663estranged
estranger10447833estranger
estranges10359983estranges
estrin6315923estrin__
estrins7315853estrin_s
estrone7413953estron_e
fasting114522833fast_ing_
fastings124011943fast_ings
fringe104013953__fringe
gasting95022763gast_ing_
gastrin839823gastrin__
gastrins9310123gastrin_s
hamstring1546003hamstring_
hamstrings1643013hamstrings
hasting114725193hast_ing_
infringe1245083infringe
lasting84725243last_ing_
lastings94214423last_ings
latrine7715123latrin_e
lustring9269723lustring_
lustrings10245553lustrings
mastering122315303mastering_
masting104325823mast_ing_
metring103215283metring_
mitring103514143mitring_
outrange92410213outrange
outring84021013outring_
outrings92811053outrings
partridge1362863partridge
pasting103826553past_ing_
pastoring12310843pastoring_
pasturing1238433pasturing_
restring91518783restring_
restrings10159293restrings
sabring102614843sabring_
sacring103115983sacring_
sacrings11278923sacrings
sating74735453sat_ing_
serine65432673_serin_e
sering74731813_sering_
seringa83310743_seringa
shrine94920053_shrin_e
singe65731133_s__inge
siring75128313_siring_
soring74731883_soring_
sorings83817253_sorings
spring94526013_spring_
springed123911313_springed
springer113311753_springer
springes114014033_springes
springs104415923_springs
springy13359663_springy
staring84527053_staring_
sting65330243_st_ing_
stinger84314683_st_inger
stingo74212163_st_ingo
stings76220183_st_ings
stingy105213203_st_ingy
storing83921123_storing_
strang75718313_strang_
stranger94715083_stranger
stranges94516763_stranges
strangle98411503_strangle
striae65422273_stri_ae
striate74218953_striate
stride75420963_stri_de
strife95318363_stri_fe
strike105619733_stri_ke
stringent1049093_stringent
stringers104210643_stringers
stringier1036713_stringier
stripe85822443_stri_pe
strive95020963_stri_ve
strong74914883_strong_
stronger9349683_stronger
strung75213023_strung_
stying105414573_stying_
swinge105614383_s_winge
syringa11366353_syringa
syringed13377583_syringed
syringes122810213_syringes
tasting84624213tast_ing_
tinge64626613__t_inge
triage72812893__triage
trine54734603__trin_e
twinge104210393__twinge
unstring9312093unstring_
unstrings1046013unstrings
vitrine102511363vitrin_e
wasting114422843wast_ing_
wastrie101210293wastri__e

Search took 10 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.1701051123.5
2DLD Change Limit1461621518.95316325.5
3Display Results1511510.0632396.8
 (SQL Overall)1786911519.18619452.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.