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

237 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
elastins8211174(None) 
elastics102710881elastics
elastin72611841elastin_
blasties102113632blasties
blasting114013432blasting
blastings12347912blastings
clastics122811412clastics
easting84924302e_asting
eastings93412952e_astings
elains64919852ela__ins
elastic93013392elasti_c
elating83423082ela_ting
elations83719122ela_tions
gelatins93414092gela_tins
lashins103915152_lashins
lasting84725242_lasting
lastings94214422_lastings
lattins74115482_lattins
plasmins12199412plasmins
plastics122412332plastics
plastids11269212plastids
actins86321103__actins
alanins7315803ala_nins
alastors8311223alastors
alations82518893ala_tions
basins85722763_bas_ins
basting104227203_basting
bastings114214693_bastings
bastions10411693_bastions
beasties102514653beasties
beastings12387653beastings
blains84516373bla__ins
blasters104116143blasters
blastie92411393blasti_e
blastier10249493blastier
blastiest111710053blastiest
blasts85116773blast__s
blatting114111653blatting
boasting113512503boasting
caseins93115053_caseins
casting104628343_casting
castings113614053_castings
celestine11147943celestine
celestines12136893celestines
ceratins102818733cera_tins
chastens13429183chastens
clashing143812193clashing
clasping133310263clasping
classics12418873classics
classing113211793classing
classis93712723classi_s
classons1037703classons
clastic113013963clasti_c
clasts84817293clast__s
coasting113615513coasting
coastings12357863coastings
colistins1149233colistins
delating103119603dela_ting
delations102616593dela_tions
delisting112710503delisting
demasting1338453demasting
easies64126633e_as_ies
easing74926463e_as_ing
easters75125683e_asters
easts57530323e_ast__s
eating75134403e_a_ting
eatings84616443e_a_tings
egesting1039013egesting
egestions1046703egestions
eglantine1044973eglantine
eglantines1143673eglantines
einsteins944153einsteins
ekistics1485703ekistics
elain55324703ela__in_
elans55527753ela___ns
elaphine1346113elaphine
elapids1036503ela_pids
elapine9310673ela_pine
elapsing1146713elapsing
elastase845643elastase
elastases946113elastases
elaterins9410033elaterins
elaters74420193ela_ters
elates65032363ela_t_es
elation73620453ela_tion
elative10312453ela_tive
elatives1139783ela_tives
electing112113783electing
elections112414973elections
elfins94810943el__fins
elisions82210423elisions
eloins65419383el__oins
elusions82610083elusions
eluting84115293el_uting
elutions82513053el_utions
emetins9812653e_metins
emptins1179403e_mptins
enacting11311363enacting
enations83316903ena_tions
enlisting1038343enlisting
eosins64419163e_os_ins
erasing8317963eras_ing
erasions8310983erasions
eristics10610193eristics
essoins737603e_ssoins
estrins7315853e__strins
etamins91511833eta_mins
euplastics1443663euplastics
evasions1136543evasions
exacting1838523exacting
exactions1838923exactions
exalting1638033exalting
existing1639073existing
fastens105511753_fastens
fasting114522833_fasting
fastings124011943_fastings
feasting122011323feasting
flashing153711553flashing
flashings16316663flashings
flattens11357483flattens
flatting123511253flatting
flavins1338543fla_vins
gaskins123510773_gaskins
gasting95022763_gasting
gastrins9310133_gastrins
gelatin83514733gela_tin_
gelatine93213313gela_tine
gelatines102910543gela_tines
gelating103015733gela_ting
gelations102513093gela_tions
gelatis83313513gela_ti_s
glassies94012273glassies
glassine9329313glassine
glassines10278043glassines
glassing10329973glassing
glistens9366593glistens
gratins84119183gra_tins
hastens106214813_hastens
hasting114725193_hasting
hematins131714683hema_tins
isatins7310773isa_tins
jasmins1637083_jasmins
keratins122313483kera_tins
laities7320343_laities
lapins84520683_la_pins
lashing114422893_lashing
lashings124412253_lashings
lasing74727983_las_ing
lassies74420103_lassies
lassis65216703_lassi_s
lasters75627693_lasters
lasts57731263_last__s
latens64620213_la_tens
latina65621143_la_tina
latinas74416463_la_tinas
latino64120473_la_tino
latinos73613803_la_tinos
lattens75014673_lattens
lattin64316223_lattin_
layins93817653_la_yins
lealties8310793lealties
leashing123310313leashing
leasing83920163leas_ing
leasings9379843leas_ings
leasts64616413least__s
lectins92515003_lectins
leptins92412693_leptins
listens74014133_listens
listing84020593_listing
listings93310043_listings
lusting83619323_lusting
lysins94610953_lys_ins
martins93322063_martins
mastics112614783_mastics
masting104325823_masting
matins84527783_ma_tins
mattins93316143_mattins
melanins10310383mela_nins
nasties73520493_nasties
pasties94529813_pasties
pastils94416173_pastils
pastina93914593_pastina
pastinas103712163_pastinas
pasting103826553_pasting
pastis84924323_pasti_s
patins87528783_pa_tins
plains85019593pla__ins
plaiting113113513plaiting
plaitings12296243plaitings
plantains1147493plantains
planting113515383planting
plantings12348403plantings
plashing143311063plashing
plasmids13236553plasmids
plasmin112410033plasmin_
plasmons12217663plasmons
plasters103518133plasters
plastic112815063plasti_c
plastid102112523plasti_d
plastrons1147133plastrons
platans93413123pla_tans
platens94213983pla_tens
platies93722543pla_ties
platina94413643pla_tina
platinas103610313pla_tinas
plating103823073pla_ting
platings113611363pla_tings
platting114813033platting
postins93721203_postins
quassins1735793quassins
recasting122414233recasting
refastens1244753refastens
relating92725443rela_ting
relations92418333rela_tions
relaxins15248683rela_xins
relisting102414353relisting
repasting122312843repasting
retasting102513413retasting
roasting93012703roasting
sasins64923103_sas_ins
satins64930483_sa_tins
sealskins1343253sealskins
slanting94115093slanting
slashing123713413slashing
slashings13316203slashings
slating83724653sla_ting
slatings94011723sla_tings
slatting94014233slatting
slattings10346073slattings
spastics1237503spastics
statins73719773sta_tins
tasting84624213_tasting
telestics1196963telestics
toasting93410583toasting
wasting114422843_wasting
yeasting12188923yeasting
zeatins16311733zea_tins

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.423422437.4
2DLD Change Limit1461622377.15620425.1
3Display Results2372370.1102154.5
 (SQL Overall)1786912377.68923239.8
 
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.