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

236 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
elastin7261184(None) 
elastic93013391elastic
elastins82111741elastins
blastie92411392blastie
blasting114013432blasting
clastic113013962clastic
easting84924302e_asting
elain55324702ela__in
elastics102710882elastics
elating83423082ela_ting
elation73620452ela_tion
gelatin83514732gela_tin
lasting84725242_lasting
lattin64316222_lattin
plasmin112410032plasmin
plastic112815062plastic
plastid102112522plastid
actin74922553__actin
alanin6317273ala_nin
alastor739663alastor
alation72920553ala_tion
anelastic1147043anelastic
aplastic1249243aplastic
astir55517093__astir
basin75026923_bas_in
basting104227203_basting
bastion9312473_bastion
beastie92412433beastie
blain75421793bla__in
blast76532573blast__
blasted104213473blasted
blaster94017303blaster
blastier10249493blastier
blasties102113633blasties
blastings12347913blastings
blasts85116773blast_s
blasty115611053blast_y
blatting114111653blatting
boasting113512503boasting
casein83216453_casein
casting104628343_casting
celestine11147943celestine
ceratin93020163cera_tin
chasten124312403chasten
clashing143812193clashing
clasping133310263clasping
classic113710113classic
classing113211793classing
classis93712723classis
classon937693classon
clast76030583clast__
clastics122811413clastics
clasts84817293clast_s
coasting113615513coasting
colistin10410553colistin
delating103119603dela_ting
delation92318083dela_tion
delisting112710503delisting
demasting1338453demasting
drastic10310873drastic
easing74926463e_as_ing
east46659103e_ast__
easter65027983e_aster
eastern74412533e_astern
eastings93412953e_astings
easts57530323e_ast_s
eaten55323053e_a_ten
eating75134403e_a_ting
egesting1039013egesting
egestion946863egestion
eglantine1044973eglantine
einstein844183einstein
ekistic1377843ekistic
elains64919853ela__ins
elan46734243ela___n
elaphine1346113elaphine
elapid939543ela_pid
elapine9310673ela_pine
elapsing1146713elapsing
elastase845643elastase
elate55335883ela_t_e
elated74725823ela_ted
elater64724203ela_ter
elaterin849903elaterin
elates65032363ela_tes
elations83719123ela_tions
elative10312453ela_tive
electing112113783electing
election102015353election
elfin84312463el__fin
elision72311103elision
eloin55923203el__oin
elusion72310953elusion
eluting84115293el_uting
elution72913823el_ution
elysian1065083elysian
emetin8613463e_metin
enacting11311363enacting
enatic8317563ena_tic
enation73419233ena_tion
enlisting1038343enlisting
entastic1048553entastic
eosin55220923e_os_in
erasing8317963eras_ing
erasion7311963erasion
ergastic11106623ergastic
eristic9814093eristic
essoin638193e_ssoin
estrin6315923e__strin
etamin81311853eta_min
euplastic1345463euplastic
evasion1036753evasion
exacting1838523exacting
exaction1738953exaction
exalting1638033exalting
existing1639073existing
fasten95114893_fasten
fasting114522833_fasting
feasting122011323feasting
flashing153711553flashing
flatten10429653flatten
flatting123511253flatting
flavin1239303fla_vin
gaskin113610583_gaskin
gasting95022763_gasting
gastrin839833_gastrin
gelati73814533gela_ti_
gelatine93213303gela_tine
gelating103015733gela_ting
gelatins93414093gela_tins
gelation93014433gela_tion
gelatis83313513gela_tis
glassie8329493glassie
glassine9329313glassine
glassing10329973glassing
glisten8418083glisten
gratin74520583gra_tin
hasten95718563_hasten
hasting114725193_hasting
hematin121516023hema_tin
inelastic1146463inelastic
isatin6412213isa_tin
jasmin1538073_jasmin
keratin113314153kera_tin
lactic10713493_lactic
lain46146283_la__in
lapin75222923_la_pin
lashing114422893_lashing
lashins103915153_lashins
lasing74727983_las_ing
lassi56316853_lassi_
lassie64917743_lassie
lassis65216703_lassis
last46260323_last__
lasted74323603_lasted
laster64830633_laster
lastings94214423_lastings
lastly93310873_lastly
lasts57731263_last_s
laten54328343_la_ten
lati46438273_la_ti_
latina65621143_la_tina
latino64120473_la_tino
latten65018203_latten
lattins74115483_lattins
layin84720333_la_yin
leashing123310313leashing
leasing83920163leas_ing
least56134883least__
leasts64616413least_s
lectin82515013_lectin
leptin82512333_leptin
listen64816813_listen
listing84020593_listing
lusting83619323_lusting
lysin84512783_lys_in
martin84122523_martin
mastic103119173_mastic
masting104325823_masting
mastix152310513_mastix
matin75132853_ma_tin
mattin84416633_mattin
melanin9310893mela_nin
nastic82915973_nastic
oblasti945953oblasti_
pastie85525523_pastie
pastil85018323_pastil
pastina93914593_pastina
pasting103826553_pasting
pastis84924323_pastis
patin76832853_pa_tin
plain74823303pla__in
plaiting113113513plaiting
plantain1047903plantain
planting113515383planting
plashing143311063plashing
plasmic13249113plasmic
plasmid12239553plasmid
plasmins12199413plasmins
plasmon11257983plasmon
plaster93318693plaster
plastics122412333plastics
plastids11269213plastids
plastron1046913plastron
platan83913693pla_tan
platen84518203pla_ten
platina94413643pla_tina
plating103823073pla_ting
platting114813033platting
postin83521033_postin
quassin1645943quassin
recasting122414233recasting
refasten1136103refasten
relating92725443rela_ting
relation82619773rela_tion
relaxin14239183rela_xin
relisting102414353relisting
repasting122312843repasting
retasting102513413retasting
roasting93012703roasting
sasin54626573_sas_in
satin55935223_sa_tin
sealskin1243543sealskin
slain54923573sla__in
slanting94115093slanting
slashing123713413slashing
slating83724653sla_ting
slatting94014233slatting
spastic11310383spastic
statin63921473sta_tin
tasting84624213_tasting
telestic10118953telestic
toasting93410583toasting
wasting114422843_wasting
yeasting12188923yeasting
zeatin15412823zea_tin

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.436409841.7
2DLD Change Limit1340272366.79619721.5
3Display Results2362360.0932537.6
 (SQL Overall)1786912367.32524394.7
 
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.