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

280 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
echini11471043(None) 
eching126315561eching
aching126521972aching
acini75718982ac_ini
chili106218482_chili
chin96934742_chin_
china105022472_china
chine105231722_chine
chink145321592_chink
chino105823312_chino
chins105631462_chins
echidna1343722echidna
echinoid1445992echinoid
echinus1236202echinus
echoing1358612echoing
etching134511842etching
leching134613652leching
peching154513902peching
tahini939882tahini
zecchini2442382zecchini
zechin20137702zechin_
zechins21137122zechins
aahing1019015763aahing
achene11313813achene
achier113914263achier
acing87429153ac_ing
acinic104713543ac_inic
aclinic11188973aclinic
actin74922553actin_
acting95920983acting
actinia91710853actinia
actinic111810553actinic
actins86321103actins
ahing98928343_ahing
archine125817053archine
arching136216693arching
ashing107824093ashing
baching156017753baching
beaching164114143beaching
becking164416073becking
behind1238063behind
belching16349153belching
benching163411343benching
bethink1677203bethink
bikini12418913bikini
blini75519273_blini
caching156317503caching
cain65643913_cain_
cains75334303_cains
casini84615863casini
ceding104014803ceding
ceili75814793_ceili
cering94522533cering
chai95929903_ch_ai
chain105723673_chain_
chaine115119223_chaine
chains114819703_chains
chang115418563_chang
chant105932693_chant
chi86228653_ch__i
chia96026623_chi_a
chianti1236603_chianti
chiao105618363_chiao
chias104625513_chias
chic115925203_chi_c
chica125818263_chica
chichi1637093_chichi
chick165419133_chick
chico124218253_chico
chics123920943_chics
chid106626403_chi_d
chide115321013_chide
chief134419473_chief
chiel104918973_chiel
child114516223_child
chile105626893_chile
chilis115517873_chilis
chill105619873_chill
chilli114312773_chilli
chimb144813563_chimb
chime125322593_chime
chimp145216473_chimp
chinas115119383_chinas
chinch163911223_chinch
chined125620063_chined
chines115029173_chines
chining133316843_chining
chinks155817573_chinks
chinky185610543_chinky
chinos115018693_chinos
chints115117833_chints
chintz204212023_chintz
chip116726423_chi_p
chips125721253_chips
chirk144516183_chirk
chirm125317063_chirm
chiro105320343_chiro
chirp124717163_chirp
chirr105015903_chirr
chiru105317153_chiru
chis95933313_chi_s
chit96937463_chi_t
chitin113114953_chitin
chits105424573_chits
chive135117623_chive
chivy164810363_chivy
chon96627793_chon_
chunk144812383_chunk
cine66242943_c_ine
cline76428533_cline
cling86424673_cling
clinic104312793_clinic
clink115320043_clink
cochin131313203cochin_
cochins141413093cochins
coin66645353_coin_
coins75834553_coins
coni65534803_c_oni
cuing85420193_cuing
decking153915593decking
decline103716613decline
earing75235483earing
easing74926463easing
eating75134403eating
ebbing1137063ebbing
eccrine1137283eccrine
echard1249223echard
eche97520283ech__e
eched116919223ech_ed
eches106322163ech_es
echidnae1442903echidnae
echidnas1443383echidnas
echinate1359403echinate
echinoids1544223echinoids
echo96615953ech__o
echoed125211153echoed
echoer114011103echoer
echoes114715523echoes
echoey14397853echoey
echoic1339043echoic
echoism1447363echoism
echos105216463ech_os
echt95722903ech__t
edging93510713edging
egging93210983egging
eking106614983e_king
elain55324703elain_
elains64919853elains
elfin84312463elfin_
elfins94810943elfins
elhi7612403elh__i
elint55436473e_lint
eloin55923203eloin_
eloins65419383eloins
enchain1248853enchain_
enchains1348523enchains
enchant12313103enchant
encina8310443encina
ending83220253ending
engine71114863engine
enwind10298083enwind
eosin55220923eosin_
eosine64519413eosine
eosinic947713eosinic
eosins64419163eosins
ephebi1345083ephebi
ephori1139603ephori
equine151711573equine
ermine8416923ermine
errhine1036593errhine
erring73816473erring
etchant1249813etchant
etchings14396293etchings
ethane94613243ethane
ethene93312923ethene
ethic101511223ethi_c
ethics11169283ethics
ethinyl1343433ethinyl
ethion938813ethion
ethions1038483ethions
ethnic1148853ethnic
ethyne12407153ethyne
eucaine939243eucaine
euchring1436613euchring
euripi856083euripi
exhibit1945253exhibit
exine125518493e_xine
exing136016813e_xing
eyeing10429363eyeing
eying96117923e_ying
fetching17298413fetching
gecking154111363gecking
hili75626633__hili
hin67559563__hin_
hind85529753__hind
hins76447993__hins
hint77455743__hint
icing86017743ic_ing
inching134414323inching
itching134011683itching
kachina1637663kachina
kecking134111883kecking
leaching143012833leaching
lectin82515013lectin_
lectins92515003lectins
leeching14318373leeching
letching143810263letching
machine14313493machine
mechanic1747613mechanic
meshing134513813meshing
miching152911803miching
mini65634543__mini
necking143913893necking
niching133612433niching
ochone11311293ochone
ochring13156673ochring
ohing96018803_ohing
oohing104412933oohing
ouching134314903ouching
pachisi14329523pachisi
panini8314273panini
peaching163613643peaching
pechan13511543pechan_
pechans14810503pechans
pecking164017783pecking
pecorini1246553pecorini
pectin102615533pectin_
pectins112315233pectins
perching163711633perching
rapini84714683rapini
reaching143317203reaching
recking144319923recking
recline94020493recline
recoin84320293recoin_
recoins94019243recoins
reshine102816943reshine
retching143412173retching
rethink1488883rethink
rhino84614323_rhino
ruching133612933ruching
schism1338173schism
schist11312653schist
schizo20115993schizo
schizy23115043schizy
shin75634303_shin_
shine85533093_shine
shins85131043_shins
shiny115122143_shiny
sphinx1866203sphinx
tachinid1446243tachinid
tahinis1048003tahinis
teaching143612603teaching
techie11511723techi_e
techier1269243techier
techies12513603techies
techily1537123techily
technic1496903technic
techno1135953tech_no
termini93410813termini
thin76732383_thin_
thine85026853_thine
thing96622963_thing
think125018793_think
thins85826323_thins
uncini8310153uncini
urchin1138743urchin_
urchins1238863urchins
vahine123612113vahine
wahine123813013wahine
welching17287363welching
wenching17328863wenching
whin105225693_whin_
whine116022813_whine
whins114922333_whins
whiny144915573_whiny
yogini10449143yogini
zecchin2343703zecchin_
zecchino2442663zecchino
zecchins2443533zecchins
zucchini2442153zucchini

Search took 7 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 Filter1786911127160.1401276364.3
2DLD Change Limit1127162806.03018692.5
3Display Results2802800.0933010.8
 (SQL Overall)1786912806.26328531.2
 
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.