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 “tzarisms” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

91 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
tzarisms196521(None) 
czarisms2155751czarisms
tsarisms1056651tsarisms
tzarism1866321tzarism_
tzarists1755691tzarists
charisms15710262charisms
czarism2056422czarism_
czarists1966222czarists
tourisms1037612tourisms
tsarism958252tsarism_
tsarists857302tsarists
tzardoms2043272tzardoms
tzarinas1733972tzarinas
tzarist1659102tzaris_t
agisms9399393__agisms
alarmisms1345003alarmisms
arises65233803__arises
atavisms1346993atavisms
baalisms1238033baalisms
bariums1139143_bariums
binarisms1346413binarisms
boyarisms1645443boyarisms
charism14712203charism_
charisma1576363charisma
charismas1655313charismas
chrisms1499143_chrisms
cladisms1336093cladisms
czardoms2243743czardoms
czarinas1935303czarinas
czarist18710223czaris_t
diarists9410363diarists
dualisms1147213dualisms
dwarfisms1841723dwarfisms
etatisms1038293etatisms
favisms1535443_favisms
imagisms1344903imagisms
lyrisms1235653_lyrisms
nanisms938833_nanisms
narcisms1267263_narcisms
ogrisms1036443_ogrisms
onanisms1048063onanisms
oralisms10610973oralisms
papisms13238543_papisms
parises94827183_parises
pianisms1249013pianisms
porisms113713453_porisms
prisms104915503__prisms
ptyalisms1685303ptyalisms
purisms114110833_purisms
racisms112310813_racisms
realisms102212163realisms
sadisms10359113_sadisms
solarisms1168813solarisms
statisms1039543statisms
tachisms1567143tachisms
tamarisks1543633tamarisks
tamises92715973t_amises
tanists7313653t_anists
tantrisms1146323tantrisms
tapises92914013t_apises
tariffs1334593t_ariffs
tarsias74013373t_arsias
tarsus6310513t_ar_sus
tearooms1047843tearooms
teratisms11410073teratisms
thairms1244453tha_irms
tharms115712243thar__ms
theisms1237763t_heisms
thoriums13166403thoriums
titanisms1147423titanisms
toadyisms1542943toadyisms
totalisms1139813totalisms
tourism939423tourism_
tourists838313tourists
triadisms1246453triadisms
trims75021473t__ri_ms
trismus935563t__rismus
tropisms1247723tropisms
truisms9106823t_ruisms
tsardoms1144133tsardoms
tsarinas835273tsarinas
tsarist7712253tsaris_t
tzardom1943733tzardom_
tzarina1635053tzari_na
tzaritza1681673tzaritza
tzaritzas1791253tzaritzas
tzars144914273tzar___s
tzuris15286913tzuri__s
uranisms1099973uranisms
verisms123011253_verisms
zaribas1836043_zaribas

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 Filter1786911461620.576310227.4
2DLD Change Limit146162917.36019859.0
3Display Results91910.0332757.6
 (SQL Overall)178691917.96922423.3
 
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.