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 “tsarism” 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
tsarism95825(None) 
tsarisms1056651tsarisms
tsarist7712251tsarist
tzarism1866321tzarism
charism14712202charism
czarism2056422czarism
sadism94113492_sadism
saris54544952_saris_
statism9412282statism
tourism939422tourism
tsadis7429132tsadis_
tsardom1044482tsardom
tsarina736652tsarina
tsarists857302tsarists
tsars56717112tsar_s_
tsoris63411192tsoris_
tsuris62710202tsuris_
tzarisms1965212tzarisms
tzarist1659102tzarist
agism84614063__agism
alarmism1245853alarmism
arise56436433__arise
asarum84610913asar_um
asarums9467613asarums
ascaris93613323ascaris_
asterism10413253asterism
atavism1238033atavism
baalism11310593baalism
barium10313513_barium
bearish123013273bearish
binarism1248353binarism
boarish123911913boarish
boyarism1546393boyarism
caesarism1345933caesarism
charisma1576363charisma
charisms15710263charisms
chrism13710673_chrism
cladism1238553cladism
czarisms2155753czarisms
czarist18710223czarist
diarist8517113diarist
dualism1049163dualism
dwarfism1742293dwarfism
escapism1444453escapism
etatism9610293etatism
fascism1436443fascism
favism1437913_favism
fusarium1344233fusarium
garish104516923_garish
imagism1285083imagism
isarithm1342013isarithm
isobarism1343833isobarism
laris54737463_laris_
lyrism1137473_lyrism
marish114319053_marish
nanism8311203_nanism
narcism1188733_narcism
naris55735293_naris_
nasalism1048203nasalism
ogrism937913_ogrism
onanism9310133onanism
oralism9513763oralism
papism122211513_papism
paris75145943_paris_
parish115022353_parish
pianism11611033pianism
porism104518063_porism
prism94820263__prism
ptyalism15115793ptyalism
purism104715063_purism
racism103214193_racism
realism93115923realism
rosarium10126913rosarium
sacrist9315423_sacrist
sadis64930853_sadis_
sadisms10359113_sadisms
sadist74221353_sadist
sakis95323673_sakis_
sarcasm1136693_sarcasm
sards64736183_sards_
sari45444043_sari__
sarin55239253_sari_n
sarins63932623_sarins
sarks96632463_sarks_
saros55238063_saros_
satis55633683_satis_
schism1338173_schism
scrim95419743_scri_m
scrims104615933_scrims
seism75019023_s_eism
sexism15227653_sexism
shris84221453_shris_
solarism10810383solarism
sris45434153_s_ris_
stadium1038073stadium
stairs65416333stairs_
stardom1037763stardom
stares66038753stares_
starfish1438083starfish
staring84527053staring
stars55836573star_s_
starts65423123starts_
startsy10536703startsy
stasis63116873stasis_
statisms1039543statisms
statist7317723statist
tachism1478873tachism
tamaris9413593tamaris_
tamarisk1445473tamarisk
tamis76728733t_amis_
tanist6324593t_anist
tantrism1048373tantrism
tapis75028863t_apis_
tares57456563t_ares_
tariff12711363t_ariff
taring73932283t_aring
tarnish101611873t_arnish
tarns56433953t_arns_
taros55640823t_aros_
tarps76527113t_arps_
tars46763953t_ar_s_
tarsi55222173t_ar_si
tarsia65514273t_arsia
tartish101512633t_artish
tarts57242023t_arts_
taxis126821973t_axis_
tearier73815613tearier
teariest82417263teariest
tearily10311153tearily
tearing84021493tearing
tearoom939063tearoom
tears55436463tear_s_
terais64023513terais_
teratism10312173teratism
tetris62816293tetris_
thairm1156963tha_irm
thairms1244453thairms
tharm105916643thar__m
tharms115712243tharms_
theism1139483t_heism
thorium12208413thorium
tiaras6314553tiaras_
tigrish1137573tigrish
titanism1048213titanism
toadish1139063toadish
toadyism1443673toadyism
totalism10311093totalism
tourisms1037613tourisms
tourist7313203tourist
tovarish1445123tovarish
triadism1147553triadism
trim65329523t__ri_m
trims75021473t__rims
tropism1139293tropism
truism8118623t_ruism
tsades74310993tsades_
tsadi6379913tsadi__
tsar47819803tsar___
tsardoms1144133tsardoms
tsarinas835273tsarinas
tsaritza1791423tsaritza
tsooris734693tsooris_
tsores65113663tsores_
tsorriss842683tsorriss
tsouris735153tsouris_
tzardom1943733tzardom
tzarina1635053tzarina
tzarists1755693tzarists
tzars144914273tzar_s_
tzuris15286913tzuris_
uranism91112513uranism
uraris63817273uraris_
verism113214263_verism
wearish132310153wearish
zoarium1846093zoarium

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 Limit1340271757.00019146.7
3Display Results1751750.0632777.8
 (SQL Overall)1786911757.46923924.4
 
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.