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

225 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
czarina184595(None) 
carina84325321c_arina
czarinas1935291czarinas
tzarina1635051tzarina
carinae94318582c_arinae
carinal94318232c_arinal
carinas93622402c_arinas
caring95137992c_aring
charing133721322charing
czarevna2241252czarevna
czarism2056422czarism
czarist18710222czarist
czaritza1891952czaritza
farina94618232_farina
jarina134014062_jarina
marina84623412_marina
ocarina948032ocarina
tsarina736652tsarina
tzarinas1733972tzarinas
zariba1736982_zariba
acarine9316003acarine
amarna839793amar_na
arena55323813__arena
aria46245423__ari_a
baring95135853_baring
bearing103624773bearing
blaring104317113blaring
cabana103913563c_abana
cabin94820943c_abin_
cabins104418923c_abins
caging105321023c_aging
cain65643913c_a_in_
cains75334303c_a_ins
cairn75717513c_airn_
cairns85313303c_airns
cairny11557823c_airny
caking134624673c_aking
camisa103114323c_amisa
canine83826703c_anine
caning94128623c_aning
canna75919333c_a_nna
cantina93417253cantina
capita102913773c_apita
caprine11314233caprine
carbine112918643c_arbine
cardia9916373c_ardia
cardinal1139563c_ardinal
carding113922433c_arding
caribe103416753c_aribe
caried94528693c_aried
caries85147623c_aries
carinate103320243c_arinate
carioca1139683c_arioca
caritas93316953c_aritas
carking144322853c_arking
carlin84421823c_arlin_
carline93923613c_arline
carling103727063c_arling
carlins93921913c_arlins
carman103920743c_arman
carmine112918483c_armine
carn66245433c_ar_n_
carnal83919203c_ar_nal
carnie84421093c_arnie
carns75937563c_ar_ns
carny105822923c_ar_ny
carping123521083c_arping
carting104228283c_arting
carving133916773c_arving
casing94829103c_asing
casini84615863c_asini
casino84317553c_asino
casita82913703c_asita
cassina94113163cassina
casuarina1144973casuarina
catena8312483c_atena
cavatina1347333cavatina
caving124822613c_aving
cawing124322613c_awing
ceasing104118263ceasing
ceria75125353c_eri_a
cering94522533c_ering
cesarian1048183cesarian
chafing163911493chafing
chagrin1337893chagrin_
chagrins1437073chagrins
chain105723673cha_in_
chaine115119223cha_ine
chains114819703cha_ins
chairing143110773chairing
chamisa14328853chamisa
charging152910773charging
charier124317903charier
charily15310283charily
chariot12316213chariot
charism14712203charism
charisma1576363charisma
charity15311023charity
charka154011703char_ka
charkha19405153charkha
charking183512613charking
charming163012033charming
charring142913163charring
charting142614193charting
chasing133715893chasing
chawing164813033chawing
china105022483c__hina
chorine123218363chorine
choring133617663choring
citrin82615413citrin_
citrine92514023citrine
citrins92614363citrins
claries93422203claries
clarify1536093clarify
clarinet10317293clarinet
clarion9311663clarion
clarions10310493clarions
clarity12310913clarity
clarkia1334873clarkia
clawing133812673clawing
claying133614303claying
clearing113014883clearing
coaling103722823coaling
coaming123818323coaming
coating103525313coating
coaxing173511703coaxing
codeina104010323codeina
coquina1835743coquina
corbina111911453corbina
coria75828323c_ori_a
coring94433963c_oring
corona83817403c_orona
corrida1078503corrida
cortina91915973cortina
corvina12229503corvina
crania82418433crani_a
craning103620303craning
craping124018713craping
crating103725203crating
craving134015733craving
crazing193914583crazing
cumarin1139263cumarin_
cumarins1238643cumarins
curarine10610713curarine
curia74523773c_uri_a
curing94824783c_uring
curring103616843curring
cyanin113911453cyanin_
cyanine122911513cyanine
cyanins122910013cyanins
cyprian1445343cyprian
czar156013133czar___
czardas1934673czardas
czardom2144183czardom
czarevnas2341353czarevnas
czarisms2155753czarisms
czarists1966223czarists
czaritzas1991643czaritzas
czars164812913czar__s
daring84928683_daring
dharna1055263dhar_na
earing75235483_earing
farinas103215233_farinas
faring105231283_faring
farinha13357063_farinha
fearing113520033fearing
flaring114116803flaring
gearing92818843gearing
glaring93714883glaring
guarana886303guarana
hariana10310243_hariana
haring104233003_haring
hearing113324163hearing
jarinas143712183_jarinas
lamina84920443_lamina
larine63927043_larine
latina65621143_latina
maria75032883_mari_a
marinas93519383_marinas
marine84230403_marine
narine63422553_narine
nearing83020333nearing
oaring74225303_oaring
ocarinas1036723ocarinas
ovarian1037643ovarian
parian83223963_parian
paring94236493_paring
patina86022193_patina
platina94413643platina
raring74332873_raring
rearing83128783rearing
roaring82916003roaring
salina64221123_salina
sarcina9310733_sarcina
sarin55239253_sarin_
sarins63932623_sarins
scaring103421973scaring
searing83330923searing
sharia93116733shari_a
sharing113723243sharing
snaring83920953snaring
soaring83521893soaring
sparing104823873sparing
spartina1037983spartina
stamina9310793stamina
staring84527053staring
taring73932283_taring
tearing84021493tearing
tsarinas835273tsarinas
tzarevna204973tzarevna
tzarism1866323tzarism
tzarist1659103tzarist
tzaritza1681673tzaritza
vagina102710933_vagina
varia85824203_vari_a
varna84516173_var_na
waring105029443_waring
wearing113318863wearing
zamia165115213_zami_a
zanana153810363_zanana
zareba1736423_zareba
zaribas1836043_zaribas
zayin174512043_zayin_
zayins18409713_zayins
zoaria1548383zoari_a

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.406440125.6
2DLD Change Limit1340272256.84319586.0
3Display Results2252250.0762960.5
 (SQL Overall)1786912257.32524394.7
 
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.