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

175 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
korunas113544(None) 
koruna1035481koruna_
coronas93916902coronas
kahunas1473952kahunas
koras95927112kor__as
kormas124511232kor_mas
korun9411922korun__
koruny1334442korun_y
morulas959702morulas
torulas759842torulas
aortas65417783aor_tas
arenas65021993_arenas
bohunks1632943bohunks
boranes93720403boranes
boras75938303bor__as
boreas85421733bor_eas
borings103614243borings
borons85520543boron_s
bosuns8439383bosun_s
bounds94415803bo_unds
bournes93615023bournes
bourns84114063bourn_s
brunts85215453_brunts
bunas75126573__bunas
carinas93622383carinas
cohunes1249713cohunes
copulas113811563copulas
coquinas1944773coquinas
corbans11313173corbans
corbinas12229383corbinas
corneas94716993corneas
corns76034763cor_n_s
cornua85411903cornua_
cornual94210173cornual
cornus84816563cor_nus
corona83817403corona_
coronae94214893coronae
coronal94115763coronal
coronals103312893coronals
cortinas102212423cortinas
corvinas13238003corvinas
coryzas2134793coryzas
counts84618273co_unts
dhurnas1153443dhurnas
donas65926473do__nas
donnas75511323do_nnas
doulas75114993do_ulas
doumas95314813do_umas
douras75016723do_uras
drunks11427513_drunks
farinas103215233farinas
faunas94013633_faunas
ferulas103110753ferulas
forints10411833forints
formulas1346303formulas
fortunes1158283fortunes
forums114611843foru_ms
founds104814193fo_unds
founts94313383fo_unts
gerunds935183gerunds
goannas836223goannas
grounds9228303grounds
grunts75511853_grunts
horas86333093hor__as
horns86125333hor_n_s
hounds104413133ho_unds
inruns6359513inrun_s
jarinas143712183jarinas
jordans1566833jordans
jorums15408093joru_ms
journal1484963journal
journals1574353journals
journos14134943journos
kahuna1394103kahuna_
kanas95326913k__anas
karmas123013733kar_mas
karns96624143kar_n_s
kernes104717523ker_nes
kerns94719563ker_n_s
kerrias11289513kerrias
kinas95626913k__inas
kirns95315453kir_n_s
koalas104011663ko_alas
koans95818623ko_an_s
koas85635093ko___as
koines10415733ko_ines
kolas94822233ko__las
konks84917113ko__nks
koppas14407603ko_ppas
kora86431553kor__a_
korai97018513kor__ai
korat94934433kor__at
korats105416063kor_ats
korma115913073kor_ma_
kors85933013kor___s
koumis1237613ko_umis
koumys1543303ko_umys
kouros1039183ko_uros
krona93611793k_rona_
kroons103711243kroon_s
krubis1235003k_rubis
kuna85120703k__una_
kurgans12145653kurgans
kurtas10349883kur_tas
kurus98015633kuru__s
lacunas9138173lacunas
lagunas8156823lagunas
lorans65117603loran_s
loumas84812333lo_umas
lunas55025013__lunas
marinas93519373marinas
mizunas1843693mizunas
monas74732153mo__nas
moras76438763mor__as
morgans10310123morgans
morns75527443mor_n_s
morons84919543moron_s
morula8710473morula_
morulae958963morulae
morular978223morular
mounds93915133mo_unds
mounts84115073mo_unts
mourns84111013mourn_s
nonas55126653no__nas
norias65518183nor_ias
nounal639813no_unal
nouns56717313no_un_s
novenas1036893novenas
okras94410973okr__as
orangs74116033_orangs
orcas75918623_or_cas
organs7912913_organs
ornis54616773_or_nis
paruras9310533paruras
piranas9912603piranas
pornos85015253por_nos
porns75527343por_n_s
pounds93714383po_unds
prunes83419063_prunes
prunus8399363_prunus
punas74826753__punas
puranas9712643puranas
reruns66413743rerun_s
rotundas943573rotundas
rounds73615613ro_unds
ruanas6311263__ruanas
runes55530223__runes
rungs611819403__rungs
runs46438073__run_s
runts55927633__runts
saunas63915433_saunas
solunar735283solunar
soras55041013sor__as
sorings83817253sorings
sorns55028413sor_n_s
sorus54527583soru__s
sounds74616183so_unds
strumas9419833strumas
strunts7429543strunts
toras55540373tor__as
tortas64918253tor_tas
torula6610393torula_
torulae758553torulae
torus54329763toru__s
tronas63816893_tronas
trunks10429753_trunks
tunas54224123__tunas
varnas94212823var_nas
vicunas1285613vicunas
voduns1035053vodun_s
wounds103811633wo_unds
yokozunas255563yokozunas
youngs1035383yo_ungs
zonulas1637023zonulas
zounds164310173zo_unds

Search took 9 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.313570897.8
2DLD Change Limit1340271758.14016465.2
3Display Results1751750.0632777.8
 (SQL Overall)1786911758.51620983.0
 
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.