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

258 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
kerrias1128951(None) 
kerria10339911kerria_
kerries113317911kerries
berries94423552berries
cerias83321982ce_rias
derries83124622derries
derris73615272derri_s
ferias95020392fe_rias
ferries103521082ferries
hernias10310772hernias
herries104025072herries
jerrids15277742jerrids
jerries143817512jerries
kermis124012392kermi_s
perries93226602perries
serries73925352serries
skerries12168672skerries
terbias9310742terbias
terras63516972terr_as
terries73425632terries
territs72714502territs
aerial64625713ae_rial
aerials74017553ae_rials
aeries64737783ae_ries
agrias74315393_agrias
anergias947173anergias
anurias7312253anurias
aporias9315153aporias
arias55438023__arias
arras55626133_arr_as
arris56824683_arri_s
barrios9310773barrios
begrims1276763begrims
berlins93216013berlins
berried103714043berried
berthas12398763berthas
cardias10715113cardias
carries94328013carries
cercarias1346883cercarias
cercis104614493cerci_s
ceria75125353ce_ria_
cherries131812983cherries
corridas1177313corridas
corries94026793corries
curries93723163curries
dearies83526273dearies
debris93311493debri_s
decrial10310323decrial
decrials1137133decrials
decries103319803decries
derails84216393derails
derbies103016053derbies
dermas94116813de_rmas
dermis94717163dermi_s
derrick1435803derrick
derricks1544433derricks
derrises93012783derrises
durras74713373durr_as
durries83817353durries
eras45441503_e_r_as
ericas8315463_ericas
erratas736863_erratas
erring73816483_erring
errors63311313_errors
errs45622533_err__s
ervils948773_ervils
eyras84715923_eyr_as
eyries93816813_eyries
feria85922713fe_ria_
feriae95618603fe_riae
ferial94621253fe_rial
ferlies103216693ferlies
fermis114313503fermi_s
ferrels10248623ferrels
ferrets103111393ferrets
ferriage1245463ferriage
ferriages1345663ferriages
ferric1139993ferri_c
ferried113411523ferried
ferrite103312753ferrite
ferrites112312833ferrites
ferrous1049793ferrous
ferrums1265983ferrums
ferulas103110753ferulas
gerardias1144403gerardias
gerbils1037303gerbils
glorias81610323glorias
gurries83515953gurries
harries103525493harries
hegiras1136103hegiras
hejiras1744233hejiras
henries102718283henries
herdics13249523herdics
hermits12312143hermits
hernia9312293hernia_
herniae1039043herniae
hernial10310433hernial
heroics122912003heroics
heroins103518013heroins
herried113514453herried
herring113615883herring
herrings12379533herrings
hurries103919653hurries
inertias8410383inertias
jerboas1636163jerboas
jerids142810943je_rids
jerkies183411583jerkies
jerkins18358253jerkins
jerrican1794123jerrican
jerricans1883753jerricans
jerrid14259143jerri_d
kalmias1347973kalmias
karmas123013733k_armas
karroos1139313karroos
kauries113613193kauries
kauris103611533kauri_s
keas86337093ke___as
kebbies1537253kebbies
kefirs13396653ke_firs
keirs95313673ke__irs
kelims1278913ke_lims
kellies113516853kellies
keloids1288663keloids
kelpies13289903kelpies
kelvins14106563kelvins
kepis115313363ke_pi_s
keramics1644823keramics
keratins122313483keratins
kerbing14308483kerbing
kerbs115013673ke_r_bs
kerfing15307533kerfing
kerfs125413573ke_r_fs
kermes124616123ke_rmes
kermess13396223kermess
kermises14248313kermises
kernels11417953kernels
kernes104717523ke_rnes
kerning124010893kerning
kernite1159473kernite
kernites1269113kernites
kerns94719563ke_r_ns
kerry124916093kerr__y
kerseys1433993kerseys
kerygmas1842023kerygmas
kevils13358333ke_vils
kewpies16246923kewpies
koras95927113k_or_as
kormas124511233k_ormas
korunas1135443korunas
kraits104912203k_raits
kris86423603k__ri_s
kukris934453kukri_s
kurtas10349883k_urtas
kyries133411373k_yries
latrias71913213latrias
lorries74518343lorries
marries93825283marries
medias93620783me_dias
megrims1276103megrims
mercies113817563mercies
merits8320873me_rits
merlins93015813merlins
meropias1249963meropias
merrier92612303merrier
merriest10311473merriest
merrily1238633merrily
metrics11312363metrics
morris83814733morri_s
murras84916003murr_as
murrhas12286173murrhas
murries94118673murries
nereids838743nereids
nereis6315343nerei_s
norias65518203_norias
nutrias739813nutrias
orris54516553_orri_s
parries93925843parries
peeries93623023peeries
pelorias10410593pelorias
pereia85217983pereia_
perils84121853pe_rils
peris75537073pe_ri_s
permian112612283permian
permits11314003permits
perrons93115483perrons
pyurias1236713pyurias
raias54631123__raias
redias74523603re_dias
redries83721713redries
refries104419733refries
rerigs74014793re_rigs
retrial7615553retrial
retrials8510823retrials
retries74129073retries
retrims93612373retrims
rias45540593___rias
sepias83616103se_pias
serails73318363serails
serais64326133serai_s
sereins73716113sereins
serial64625863se_rial
serials73919743se_rials
series64540973se_ries
serifs94017053se_rifs
serins64029673se_rins
serosas7312663serosas
serried82513963serried
sharias102516003sharias
sherries111812893sherries
sherris10168793sherri_s
sierras737863sierr_as
sirras63814863sirr_as
surras65919533surr_as
tarries73324263tarries
tarsias74013373tarsias
teargas837013teargas
tenias64720073te_nias
terais64023513terai_s
terbia8311153terbia_
terra54419663terr_a_
terrae62915213terr_ae
terrain7410853terrain
terrains8410323terrains
terrets72913583terrets
terrier73414963terrier
terriers84210823terriers
terrify1336353terrify
terrine72517573terrine
terrines82117553terrines
territ63421373terri_t
terrors73112213terrors
tertial7313863tertial
tertials8510073tertials
tertian7511193tertian
tertians839103tertians
tetras63017623tetr_as
tetris62816293tetri_s
thorias102312053thorias
urbias839093_urbias
uremias9249503uremias
varias95019903_varias
veeries102916893veeries
veratrias1246563veratrias
verbids13259203verbids
verdins112812333verdins
verglas1137813verglas
veritas103012753veritas
vermian12329713vermian
vermis114214963vermi_s
verrucas1343923verrucas
wearies103020223wearies
wherries14179023wherries
worries104117133worries
worrits10258683worrits
xenias133712973xe_nias
yerbas11119293ye_rbas
yttrias1044523yttrias
zebras1737853zebr_as

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340272586.12621878.4
3Display Results2582580.0763394.7
 (SQL Overall)1786912586.35828104.9
 
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.