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

292 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
kerria1033991(None) 
kerrias11289511kerrias
ceria75125352ce_ria
derris73615272derris
feria85922712fe_ria
ferric1139992ferric
hernia9312292hernia
jerrid14259142jerrid
kermis124012392kermis
kerries113317912kerries
kerry124916092kerr_y
pereia85217982pereia
terbia8311152terbia
terra54419652terr_a
territ63421372territ
aecia73819283ae_cia
aerial64625713ae_rial
aerie54634603ae_rie
aerobia939463aerobia
agria65517143_agria
anergia847363anergia
anuria6313103anuria
aporia8315863aporia
aria46245423__aria
arriba867673_arriba
arris56824683_arris
atria56022333_atria
barrio8312573barrio
bedrid1039943bedrid
begrim11118333begrim
berlin83116373berlin
berried103714043berried
berries94423553berries
berry104521763berr_y
bertha11429173bertha
cardia9916373cardia
cercaria1246953cercaria
cerci93716393cerci_
cercis104614493cercis
cerias83321973ce_rias
ceric94023093ce_ric
cervid1239323cervid
cervix1865163cervix
cirri7710723cirri_
coria75828303_coria
corrida1078493corrida
corrie83621213corrie
curia74523763_curia
currie84317253currie
dearie73319813dearie
debris93311493debris
decrial10310323decrial
deliria868303deliria
derail74218813derail
derma84918513de_rma
dermic114511913dermic
dermis94717163dermis
derrick1435803derrick
derries83124623derries
derry94721373derr_y
durra65315793durr_a
durrie73713253durrie
eerie55228533_eerie
entia5318203_entia
era35741503_e_r_a
erica7316543_erica
err35626533_err__
errata639013_errata
erred65915673_erred
erring73816473_erring
error53712233_error
errs45622533_err_s
ervil8310303_ervil
eyra76217553_eyr_a
eyrie88117833_eyrie
eyrir8359653_eyrir
feirie939553feirie
feriae95618603fe_riae
ferial94621253fe_rial
ferias95020393fe_rias
ferlie92814053ferlie
fermi103914163fermi_
fermis114313503fermis
ferrel92810203ferrel
ferret93021173ferret
ferriage1245463ferriage
ferried113411523ferried
ferries103521083ferries
ferrite103312753ferrite
ferrum1147453ferrum
ferry116020803ferr_y
ferula93011173ferula
fervid1337513fervid
forrit91916623forrit
gerardia1044673gerardia
gerbil938343gerbil
germina1038493germina
gloria71910543gloria
hegira1036523hegira
hejira1644803hejira
herbaria1346093herbaria
herdic123112303herdic
herein93717793herein
herma105318883he_rma
hermai118912843hermai
hermit11519443hermit
herniae1039043herniae
hernial10310433hernial
hernias10310773hernias
heroic113516923heroic
heroin94420593heroin
herried113514453herried
herries104025073herries
herring113615873herring
herry114922473herr_y
horrid10311553horrid
hydria13227903hydria
inertia7410203inertia
jerboa1535633jerboa
jerid132316423je_rid
jerkin17258113jerkin
jerrican1794123jerrican
jerrids15277743jerrids
jerries143817513jerries
jerry155016183jerr_y
kalmia1238893kalmia
karma113415003k_arma
karmic1438113karmic
karroo10410013karroo
kauri93811843kauri_
kauris103611523kauris
kea76540913ke___a
kebbie1435803kebbie
kefir12457913ke_fir
kefirs13396653kefirs
keir86217873ke__ir
keirs95313673keir_s
kelim11912543ke_lim
keloid11812613keloid
kelpie12308613kelpie
kelvin13117323kelvin
kepi105315633ke_pi_
kepis115313363ke_pis
keramic1537233keramic
keratin113314153keratin
kerb104322713ke_r_b
kerbed13339693kerbed
kerbing14308483kerbing
kerbs115013673ke_rbs
kerf115827463ke_r_f
kerfed14358223kerfed
kerfing15307533kerfing
kerfs125413573ke_rfs
kermes124616123kermes
kern85326213ke_r_n
kerne94718213ke_rne
kerned114112923kerned
kernel104010583kernel
kernes104717523kernes
kerning124010893kerning
kernite1159473kernite
kerns94719563ke_rns
kersey1336783kersey
kerygma1741963kerygma
kevil12399863ke_vil
kewpie15465413kewpie
kora86431553k_or_a
korai97018513korai_
korma115913073k_orma
koruna1035483koruna
krait94726773k_rait
kris86423603k__ris
krona93611793k_rona
kukri835043kukri_
kukris934453kukris
kurta95113913k_urta
kyrie123712903k_yrie
latria62313583latria
maria75032883_maria
media84721713me_dia
megrim1178043megrim
merit7339183me_rit
merlin83916683merlin
meropia1149613meropia
merrier92612303merrier
merrily1238633merrily
merry104721483merr_y
metric10314673metric
morris83814723morris
murra74519083murr_a
murrha11366453murrha
nereid7312923nereid
nereis6315343nereis
noria55722183_noria
nutria639903nutria
orra46120723_orr_a
orris54516553_orris
peerie83617893peerie
peloria9310953peloria
pennia84412973pennia
perdie94718513perdie
perea75026443pe_rea
peri65636973pe_ri_
peridia10312363peridia
peril75425953pe_ril
peris75537073pe_ris
permian112612283permian
permit10321683permit
pernio8513143pernio
perries93226603perries
perron83216623perron
perry105222713perr_y
pyuria1136953pyuria
raia46638383__raia
realia6314593realia
redia65524483re_dia
rerig64018483re_rig
retia55326113re_tia
retrial7615553retrial
retrim83514873retrim
ria36745503___ria
scoria8513483scoria
sepia75318673se_pia
sera46141393se_r_a
serai56830163serai_
serail64222673serail
serais64326133serais
serein63318463serein
serial64625853se_rial
serif84132123se_rif
serin55434443se_rin
serosa6313023serosa
serried82513963serried
serries73925353serries
serry84824123serr_y
sharia93116723sharia
sherris10168793sherris
sierra637313sierr_a
sirra54416323sirr_a
skerries12168673skerries
skerry13356103skerr_y
stria55723203_stria
surra55521343surr_a
tarsia65514273tarsia
telia55821143te_lia
tenia55324483te_nia
terai53525483terai_
terais64023503terais
terbias9310743terbias
terbic10410963terbic
terga63315643te_rga
terrae62915203terrae
terrain7410833terrain
terraria847003terraria
terras63516953terras
terret63425623terret
terrier73414963terrier
terries73425613terries
terrify1336353terrify
terrine72517573terrine
territs72714493territs
terror63811723terror
terry84721873terr_y
tertial7313853tertial
tertian7511193tertian
tetra53417953tetr_a
tetri52716453tetri_
tetris62816293tetris
thoria93012883thoria
torrid7311853torrid
urbia7311133_urbia
uredia73610063uredia
uremia82910893uremia
varia85824203_varia
velaria1038923velaria
vera76828843ve_r_a
veratria1146363veratria
verbid122311313verbid
verdin103113023verdin
vermian12329713vermian
vermin113414523vermin
vermis114214963vermis
vernix1636633vernix
verruca1243713verruca
wirra83210823wirr_a
worrit92313313worrit
xenia124814773xe_nia
xeric144315663xe_ric
yerba101010763ye_rba
yttria954803yttria
zebra1637883zebr_a
zoaria1548373zoaria

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.1731032896.0
2DLD Change Limit1127162926.03018692.5
3Display Results2922920.0933139.8
 (SQL Overall)1786912926.29628381.7
 
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.