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

107 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
classist10401038(None) 
classiest11309541classiest
classis93712721classis_
classism12407171classism
classists11296241classists
coassist10298801coassist
assist6314602__assist
bassist9312742_bassist
cassis84818852c_assis_
casuist9411302c_asuist
chassis123910662chassis_
cladist10311972cla_dist
classes94717942classes_
classic113710112classi_c
classicist1445602classicist
classico12386302classico
classics12418872classics
classier10359082classier
classify1644692classify
classily1336622classily
classing113211792classing
classisms13295522classisms
coassists11275762coassists
crassest103411522crassest
glassiest10279242glassiest
lassis65216702_lassis_
alarmist1049123alarmist
assists738473__assists
bassists1037183_bassists
blastiest111710043blastiest
brassiest11369713brassiest
brassish1346433brassish
cambist13312113c_ambist
cassia83714763c_assi_a
cassias93514343c_assias
cassina94113163c_assina
cassine93817283c_assine
cassino93512433c_assino
cassises103811743c_assises
casuists1036523c_asuists
chartist131112133chartist
chasses124017503chasses_
chastest1349703chastest
chastise1348173chastise
cladism1238553cla_dism
cladists1136723cla_dists
clammiest1535733clammiest
clankiest1536663clankiest
clannish1345263clannish
clashes124017283clashes_
clashing143812193clashing
clasping133310263clasping
clasps104512093cla_sps_
claspt104513413cla_s_pt
class75525483cla_s_s_
classed104113653class_ed
classer93614613class_er
classers104111833classers
classical1345293classical
classicism1664223classicism
classicists1553783classicists
classiness12196313classiness
classless1143843classless
classmate1344863classmate
classon937693class_on
classons1037703classons
classy11379043cla_s_sy
clast76030583cla___st
clastic113013963clasti_c
clastics122811413clastics
clasts84817293cla_sts_
clauses93813323clauses_
clayiest1337913clayiest
clayish1547943cla_yish
closest94312533cl_osest
clumsiest1335393clumsiest
coarsest1039163coarsest
coassisted1343293coassisted
consist9316033c_onsist
cosmist11311333c_osmist
crasis85020473cra_sis_
crossest1012012123crossest
czarist18710223cza_rist
fascist1239213_fascist
flashiest1557983flashiest
flautist1186803flautist
flossiest12296803flossiest
gassiest93212523_gassiest
glasnost944953glasnost
glasses84414273glasses_
glassie8329493glassi_e
glassier9289083glassier
glassies94012273glassies
glassily1235463glassily
glassine9329313glassine
glassing10329973glassing
glossiest10277943glossiest
grassiest10309513grassiest
lasses64827593_lasses_
lassi56316853_lassi__
lassie64917743_lassi_e
lassies74420103_lassies
lassos64913813_lassos_
massiest103314423_massiest
plashiest1478373plashiest
playlist1347573playlist
sassiest83413613_sassiest

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.453394461.4
2DLD Change Limit1461621076.64022012.3
3Display Results1071070.0462326.1
 (SQL Overall)1786911077.13925030.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.