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

164 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
clivias126669(None) 
clivia1177231clivia_
bolivias1345392bolivias
chivies153412852chivies
civics13397822c_ivics
civies114116442c_ivies
clevis1158962clevi_s
clinics11338742clinics
clitics11279972clitics
clivers123411752clivers
accidias1346333accidias
actinias101810843actinias
ajivas1655133ajiv_as
albizias1973533albizias
alevins102110573alevins
alexias14249793alexias
alias55834603al__ias
alibies9313323alibies
alibis8311073alibi_s
aliyas93911803ali_yas
blinis85313683blini_s
bolivia1246063bolivia_
bulimias1254323bulimias
camisias12268603camisias
canvas113813333canv_as
capias10318353c_apias
cardias10715113cardias
cassias93514343cassias
caviar11310163c_aviar
caviars1238623c_aviars
cavies114525003c_avies
cavils114014393c_avils
ceibas1038503cei_bas
ceilis85413743ceili_s
celosias1048903celosias
cerias83321983c_erias
chevies153511443chevies
chias104625523c__hias
chicas135916473chi_cas
chiliad1337563chiliad
chiliads1445853chiliads
chiliasm15134513chiliasm
chiliast13117933chiliast
chilies124218303chilies
chilis115517873chili_s
chimlas1437453chimlas
chinas115119403chi_nas
chitins122713793chitins
chives144317593chiv_es
chivied16368383chivied
chivvies1954423chivvies
cilia73016763c_ilia_
cities84524853c_ities
civets115212543c_ivets
civic123412543c_ivi_c
civie103716353c_ivi_e
civil103411933c_ivi_l
civism1337243c_ivism
civisms1436073c_ivisms
civvies1555843civvies
claims105211573cl_aims
claries93422203claries
clarkias1444793clarkias
clavers124314903clavers
claves115020063clav_es
clavi104912923clavi__
clavier1239173clavier
claviers1367103claviers
clavus11347353clav_us
clerics1149333clerics
clerids1049093clerids
clevises1336903clevises
cliches144213743cliches
clicks145315113cli_cks
clients938093clients
cliffs14477593cli_ffs
clifts11519153cli_fts
climax1735653cli_max
climbs12498723cli_mbs
climes104720003cli_mes
clinal8311553cli_nal
clines84926043cli_nes
clings95716213cli_ngs
clinic104312793clini_c
clinical1247023clinical
clinks125815063cli_nks
clips96018303cl__ips
cliques18309203cliques
clitic103315053cliti_c
cloacas1136233cloacas
clovers125114663clovers
cloves114918823clov_es
cobias104014993c_obias
codeias103911223codeias
colicins12312853colicins
colitis92617353coliti_s
corvids1337683corvids
corvinas13238013corvinas
covins114618063c_ovins
crisis83716343crisi_s
critics112811093critics
culicids1345623culicids
cumbias13338963cumbias
divas95418583_div_as
elicits9311233elicits
elixirs1443543elixirs
eluvia936133eluvia_
eluvial1045853eluvial
flavins1338543flavins
fluvial1345363fluvial
glias64618493gl__ias
gliomas1035333gliomas
glorias81610323glorias
ivies84215763__ivies
ixias12488373__ixias
kivas124614733_kiv_as
lamias85020613_lamias
lavas85422223_lav_as
levies93919863_levies
levins94514653_levins
levis85818553_levi_s
lianas63713383_lianas
libras83711703_libras
lilies63021413_lilies
limas75627633_li_mas
limbas105313203_limbas
limits82514143_limits
limpas105513083_limpas
lingas75116573_lingas
linins65922143_linins
lipids94310923_lipids
lipins85016883_lipins
liras56021983_li_ras
litas54923773_li_tas
lithias1038823_lithias
livens94314893_livens
livers94927823_livers
lives86133193_liv_es
livid96714423_livi_d
livier97514593_livier
liviers104211073_liviers
living104318323_living
livings11408923_livings
livres94311863_livres
militias1048633militias
olives94313953oliv_es
olivine1038843olivine
olivines1137473olivines
pluvial1245433pluvial
pluvials1343713pluvials
pluvian1245333pluvian
privies122414263privies
salivas10309603saliv_as
salvias10279933salvias
shivas124512413shiv_as
silvas92912183silv_as
silvics1235563silvics
slivers104115253slivers
tibias839953_tibias
trivia938503trivia_
trivial1038713trivial
ulvas84511503ul_v_as
vigias104110893_vigias
vivas114815023_viv_as

Search took 8 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.423422437.4
2DLD Change Limit1340271647.37618170.7
3Display Results1641640.0602733.3
 (SQL Overall)1786911647.85922737.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.