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

148 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
czarists196622(None) 
czarisms2155751czarisms
czarist18710221czarist_
tzarists1755691tzarists
chariots1339392chariots
charisms15710262charisms
chartists14126802chartists
cladists1136712cladists
czarinas1935292czarinas
czarism2056422czaris_m
diarists9410362diarists
tsarists857302tsarists
tzarisms1965212tzarisms
tzarist1659102tzarist_
agists75713173__agists
alarmists1145933alarmists
amorists10411323amorists
aorists74215823_aorists
apiarists1147873apiarists
aquarists1856113aquarists
arises65233803__arises
arista6415293__arista
aristas7413523__aristas
aristo6414033__aristo
aristos7312373__aristos
artists74215583__artists
atavists1137573atavists
aurists74615783_aurists
aviarists1246603aviarists
barista9310813_barista
baristas1039723_baristas
cabalists1339143cabalists
cambists1437023cambists
camisas113411923c_amisas
camises114218463c_amises
carats85929023c_ar_ats
caress85720263c_ares_s
carets85330773c_ar_ets
caribes113715643c_aribes
carices114220953c_arices
caries85147623c_ari_es
carinas93622383c_arinas
carious93320283c_arious
caritas93316943c_aritas
carnets93918403c_arnets
carpets113915333c_arpets
carrots9714623c_arrots
carses85233653c_ar_ses
carts78946293c_ar__ts
casts77237793c_a__sts
casuists1036523casuists
cellists1038563cellists
centrists11410233centrists
ceramists1346713ceramists
cerises94722253c_erises
chaises124317493cha_ises
chamisas15317793chamisas
chamises153513313chamises
chamisos15307423chamisos
charases131312753charases
chariest13315503chariest_
chariot12316213chariot_
charism14712203charis_m
charisma1576353charisma
charismas1655293charismas
charity15311023chari_ty
chartist131112133chartist_
charts115823093char__ts
chemists152710323chemists
chrisms1499143c_hrisms
christy1536623c_hristy
chutists1335583chutists
chymists18285603chymists
cists76624533c___ists
cladisms1336093cladisms
cladist10311963cladist_
clarets94111103clar_ets
claries93422203clari_es
clarinets1137683clarinets
clarions10310493clarions
clarity12310913clari_ty
classists11296243classists
clasts84817293cla__sts
coassists11275763coassists
coasts85719133coa__sts
coexists1735653coexists
colorists112313593colorists
consists10310593consists
copyists1545993copyists
cosmists1237993cosmists
crests85218703c__rests
crises84529433c__rises
crisis83716343c__risis
crisps104411513c__risps
crista8311803c__rista
crits75527573c__ri_ts
crusts84916543c__rusts
cubists11359023c_ubists
cultists10107633cultists
cyclists1545713cyclists
czardas1934673czar_das
czardases2143033czardases
czardoms2243743czardoms
czarina1845953czari_na
czaritza1891953czaritza
czaritzas1991643czaritzas
czars164812913czar___s
dialists9411413dialists
diarist8517113diarist_
dualists958243dualists
florists1138813florists
grists74716483__grists
harpists1338093_harpists
imagists1175113imagists
jurists14409123_jurists
karsts106012943_kar_sts
lariats7615053_lariats
lyrists1036963_lyrists
maists85817573_ma_ists
metrists1039843metrists
narcists1078103_narcists
ocularists1284963ocularists
onanists838413onanists
oralists8611793oralists
papists112110453_papists
parises94827183_parises
pianists1049013pianists
purists94014073_purists
querists1736543querists
racists92613323_racists
rapists92510743_rapists
realists83014833realists
sacrists1039563sacrists
sadists83310853_sadists
scenarists1245113scenarists
sitarists949373sitarists
statists8310163statists
tanists7313653_tanists
tourists838313tourists
tsarisms1056653tsarisms
tsarist7712253tsarist_
tzarinas1733973tzarinas
tzarism1866323tzaris_m
verists103613673_verists
votarists1298593votarists
waists97415453_wa_ists
wrists95415643__wrists
zaribas1836043_zaribas

Search took 9 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.1561145455.1
2DLD Change Limit1461621488.31317582.3
3Display Results1481480.0463217.4
 (SQL Overall)1786911488.51520985.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.