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

163 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
tzarina163505(None) 
czarina1845951czarina
tsarina736651tsarina
tzarinas1733971tzarinas
carina84325322_carina
czarinas1935292czarinas
farina94618232_farina
jarina134014062_jarina
marina84623412_marina
ocarina948032ocarina
taring73932282t_aring
tearing84021492tearing
tsarinas835272tsarinas
tzarevna204972tzarevna
tzarism1866322tzarism
tzarist1659102tzarist
tzaritza1681672tzaritza
zariba1736982_zariba
acarine9316003acarine
amarna839793amar_na
arena55323813__arena
aria46245423__ari_a
baring95135853_baring
bearing103624773bearing
blaring104317113blaring
carinae94318583_carinae
carinal94318233_carinal
carinas93622403_carinas
caring95137993_caring
charing133721323charing
czarevna2241253czarevna
czarism2056423czarism
czarist18710223czarist
czaritza1891953czaritza
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
stearin7312003stearin_
stearine8311903stearine
stearins8312143stearins
tacrine9311293tacrine
taenia6313193t_aenia
tafia84215493t_afi_a
tahini939893t_ahini
taiga64115663t_a_iga
tain45548073t_a_in_
tains54936323t_a_ins
taint55542283t_a_int
takin94921303t_akin_
taking114725953t_aking
takins105117403t_akins
talaria7412513talari_a
tamarin9311913tamarin_
tamarind1147023tamarind
tamarins10310843tamarins
taming94023433t_aming
taping94222393t_aping
tarama8412733t_arama
tariff12711363t_ariff
tarn46842723t_ar_n_
tarnal63716503t_ar_nal
tarns56433953t_ar_ns
tarpan82814293t_arpan
tarring83318303tarring
tarsia65514273t_arsia
tartan64217513t_artan
tartana73010193t_artana
tarting84222653t_arting
tarzan152910753t_arzan
taurine7311363taurine
tawing104521553t_awing
taxing143816713t_axing
teaming103917593teaming
tearier73815613tearier
tearily10311153tearily
teasing83918513teasing
tegmina1035243tegmina
terrine72517573terrine
thawing14378683thawing
therian10311293therian
thoria93012893thori_a
tiara5315913tiar__a
tiering8315253tiering
tiring74023093t_iring
touring82915193touring
tracing103720153tracing
trading93517973trading
train56529113tra_in_
trains64725343tra_ins
trinal6516963t__rinal
trine54734603t__rine
trona54118953t__rona
tsarevna1141153tsarevna
tsarism958253tsarism
tsarist7712253tsarist
tsaritza1791423tsaritza
twain86313623twa_in_
twains95811183twa_ins
tyring104613023t_yring
tzar136315373tzar___
tzardom1943733tzardom
tzarevnas215953tzarevnas
tzarisms1965213tzarisms
tzarists1755693tzarists
tzaritzas1791253tzaritzas
tzars144914273tzar__s
tzuris15286913tzuri_s
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 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.390458182.1
2DLD Change Limit1340271636.40620922.1
3Display Results1631630.0632587.3
 (SQL Overall)1786911636.85926052.0
 
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.