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

206 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
clivia117723(None) 
clivias1266691clivias
bolivia1246062bolivia
cilia73016762c_ilia
civic123412542c_ivic
civie103716352c_ivie
civil103411932c_ivil
clavi104912922clavi_
clevis1158962clevis
clinic104312792clinic
clitic103315052clitic
eluvia936132eluvia
livid96714422_livid
trivia938512trivia
accidia1247003accidia
aclinic11188973aclinic
actinia91710863actinia
ajiva1586803ajiv_a
albizia1864093albizia
alevin92511513alevin
alexia132910463alexia
alibi7514233alibi_
alibis8311073alibis
alive85722513aliv_e
aliya83713483ali_ya
alluvia1045193alluvia
alodia71112453alodia
blini75519273blini_
blinis85313683blinis
bolivias1345393bolivias
bulimia1145043bulimia
cambia124913153cambia
camisia112810243camisia
cardia9916383cardia
cassia83714763cassia
caviar11310163c_aviar
cavie104621593c_avie
cavil103816493c_avil
ceiba938703cei_ba
ceili75814793ceili_
ceilis85413743ceilis
celosia939463celosia
ceria75125363c_eria
cervid1239323cervid
cervix1865163cervix
chia96026623c__hia
chica125818263chi_ca
chili106218483chili_
chiliad1337563chiliad
chilis115517873chilis
chimla1337593chimla
china105022483chi_na
chitin113114963chitin
chive135117623chiv_e
chives144317593chives
chivied16368383chivied
chivies153412853chivies
chivvy20374433chivvy
chivy164810363chiv_y
circa9311403c_irca
civet105828733c_ivet
civics13397823c_ivics
civies114116443c_ivies
civism1337243c_ivism
civvy16435463c_ivvy
claim95616913cl_aim
clarkia1334873clarkia
clave105420153clav_e
claver113816973claver
claves115020063claves
clavier1239173clavier
clavus11347353clavus
cleric10612133cleric
clerid9312413clerid
clever114611533clever
cliche133712453cliche
click135217953cli_ck
clicks145315113clicks
client8316343client
cliff135917133cli_ff
cliffs14477593cliffs
cliffy17435243cliffy
clift106422193cli_ft
clifts11519153clifts
climax1735653climax
climb115413593cli_mb
climbs12498723climbs
clime95720893cli_me
climes104720003climes
clinal8311553clinal
clinch133910353clinch
cline76428533cli_ne
clines84926043clines
cling86424673cli_ng
clings95716213clings
clingy12659063clingy
clinical1247033clinical
clinics11338743clinics
clink115320043cli_nk
clinks125815063clinks
clip86924003cl__ip
clips96018303cli_ps
clipt96324273cli_pt
clique17289193clique
cliquy20324713cliquy
clitics11279973clitics
clivers123411753clivers
cloaca1037263cloaca
clonic104914673clonic
clove105619443clov_e
cloven114211513cloven
clover114617123clover
cloves114918823cloves
cnida878953cni_da
cobia94117513c_obia
codeia94112193codeia
colicin11313743colicin
colitic112916193colitic
colitis92617353colitis
colluvia1343893colluvia
comitia1139723comitia
conidia1069303conidia
coria75828323c_oria
corvid12310473corvid
corvina12229503corvina
covin105621123c_ovin
crania82418433crania
crisic103611843crisic
crisis83716343crisis
crissa837623crissa
crista8311803crista
critic103616813critic
culicid1247383culicid
cumbia12379893cumbia
curia74523783c_uria
deliria868313deliria
diluvia11225253diluvia
diva85920883_div_a
elicit8417203elicit
elixir1333703elixir
eluvial1045853eluvial
exuvia1644223exuvia
flavin1239303flavin
fluvial1345363fluvial
glia56423153gl__ia
glioma935953glioma
gloria71910553gloria
ilia46026823__ilia
illuvia1044273illuvia
inia45024703__inia
ixia115713213__ixia
kiva116516413_kiv_a
labia75219013_labia
lamia75324323_lamia
lava76725423_lav_a
leva77020713_lev_a
levin84816413_levin
levis85818553_levis
liana53915893_liana
libra74712423_libra
licit74327683_licit
lima65734133_li_ma
limba95414983_limba
limina83514503_limina
limit73126343_limit
limpa97014463_limpa
linga66820823_linga
linin58025523_linin
lipa68425923_li_pa
lipid85916173_lipid
lipin75518893_lipin
lira46928683_li_ra
liri45128253_liri_
litai55216363_litai
lithia939333_lithia
live76540993_liv_e
lived95523723_lived
liven85021733_liven
liver85132963_liver
lives86133193_lives
livier97514593_livier
living104318323_living
livre85613253_livre
lixivia1743053lixivia
logia68116603_logia
milia72719573_milia
militia949733militia
oidia6314953_oidia
olive84817153oliv_e
olives94313953olives
olivine1038843olivine
plica9613373pli_ca
pluvial1245433pluvial
pluvian1245333pluvian
saliva93110743saliv_a
salvia93310753salvia
shiva115915003shiv_a
silva82714023silv_a
sliver94116593sliver
tibia7312403_tibia
trivial1038713trivial
ulva75412693ul_v_a
via65636243___via
vigia94813273_vigia
viva106119093_viv_a
vivid125112313_vivid

Search took 6 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.373479064.3
2DLD Change Limit1127162065.31321215.1
3Display Results2062060.0633269.8
 (SQL Overall)1786912065.74931082.1
 
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.