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

180 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
echinus123620(None) 
acinus8311252ac_inus
chiaus113611312_chiaus
chinas115119402_chinas
chines115029172_chines
chinks155817572_chinks
chinos115018692_chinos
chins105631462_chin_s
chints115117832_chints
chirus114615692_chirus
echidnas1443382echidnas
eching126315562echin_g
echini114710432echin_i
etchings14396292etchings
zechins21137122zechin_s
achenes12313493achenes
achiness1339703achiness
aching126521973achin_g
acinous9310933ac_inous
actings104512463actings
actins86321103actin_s
archines133815253archines
archings14499863archings
behinds1335283behinds
bethinks1765043bethinks
cains75334303_cain_s
chaines124518733_chaines
chains114819703_chain_s
changs125215373_changs
chants115020393_chants
chias104625523_chi_as
chicas135916473_chicas
chicks175317593_chicks
chicos134614833_chicos
chics123920943_chi_cs
chides124620473_chides
chiefs14509653_chiefs
chiels115115933_chiels
chiles115425303_chiles
chilis115517873_chilis
chills114717703_chills
chimbs153910303_chimbs
chimes134922573_chimes
chimps155713663_chimps
chin96934743_chin__
china105022483_chin_a
chinch163911233_chinch
chine105231723_chin_e
chined125620063_chined
chink145321593_chin_k
chinky185610543_chinky
chino105823313_chin_o
chintz204212033_chintz
chips125721253_chi_ps
chirks155414843_chirks
chirms135113983_chirms
chiros114617773_chiros
chirps135414003_chirps
chirrs114514983_chirrs
chiru105317153_chiru_
chis95933313_chi__s
chits105424573_chi_ts
chives144317593_chives
chorus115014773_chorus
chunks154210333_chunks
cines75239683_c_ines
clines84926043_clines
clings95716213_clings
clinks125815063_clinks
clonus85212413_clonus
cochins141413103cochin_s
coins75834553_coin_s
coitus8511893_coitus
conus76726533_c_onus
cornus84816563_cornus
crinum1039333_crinum
crinums1135863_crinums
deckings16346683deckings
declines113315803declines
earings84517713earings
eatings84616443eatings
echards1337963echards
eches106322163ech__es
echidna1343723echidna
echidnae1442903echidnae
echinate1359403echinate
echinoid1445993echinoid
echinoids1544223echinoids
echoers12459693echoers
echoes114715523ech_oes
echoing1358613echoin_g
echoisms1546143echoisms
echos105216463ech__os
echovirus1742383echovirus
ecrus75113863ec__rus
ecus65421463ec___us
edgings10256243edgings
elains64919853elain_s
elfins94810943elfin_s
elints65816423e_lints
eloins65419383eloin_s
enchains1348523enchain_s
enchants1347823enchants
encinas938723encinas
endings92910443endings
engines81114463engines
enginous946493enginous
envious1037223envious
enwinds11255553enwinds
eohippus1541063eohippus
eosines73718293eosines
eosins64419163eosin_s
ephebus1443283ephebus
equines161811593equines
ermines9416673ermines
errhines1136413errhines
etchants1346023etchants
etching134511843etchin_g
ethanes103713513ethanes
ethenes103313873ethenes
ethics11169283ethi_cs
ethinyl1343433ethinyl
ethinyls1442873ethinyls
ethions1038483ethions
ethnics1236263ethnics
ethnos947053eth_nos
ethynes13377573ethynes
eucaines1038513eucaines
euripus934623euripus
exines135715803e_xines
hilus84817643__hilus
hinds96721473__hinds
hins76447993__hin_s
hints87330623__hints
icings9428453ic_ings
itchings14386193itchings
kachinas1736343kachinas
leching134613653lechin_g
lectins92515003lectin_s
machines15312893machines
methinks1775193methinks
minus75223933__minus
neckings15346113neckings
ochrous1237943ochrous
pechans14810503pechan_s
peching154513903pechin_g
pectines121914683pectines
pectinous1345553pectinous
pectins112315233pectin_s
reclines103718543reclines
recoins94019243recoin_s
reshines112615443reshines
rethinks1576033rethinks
rhinos94411123_rhinos
ricinus9408123ricinus
ruchings14287073ruchings
schisms1437173schisms
schists1248543schists
schizos21115433schizos
shines95028913_shines
shins85131043_shin_s
sinus55523853__sinus
tahinis1048013tahinis
teachings15296553teachings
techies12513603techi_es
technics1585463technics
technos1236183tech_nos
terminus1037393terminus
things104914303_things
thinks134613363_thinks
thins85826333_thin_s
uncinus937403uncinus
urchins1238863urchin_s
vahines133410523vahines
wahines133111173wahines
whines125120103_whines
whins114922333_whin_s
zecchinos2541723zecchinos
zecchins2443533zecchin_s
zechin20137703zechin__

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.423422437.4
2DLD Change Limit1340271806.93619323.4
3Display Results1801800.0632857.1
 (SQL Overall)1786911807.42224075.9
 
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.