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

294 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
classis9371272(None) 
cassis84818851c_assis
chassis123910661chassis
classes94717941classes
classic113710111classic
classics12418871classics
classism12407171classism
classist104010381classist
lassis65216701_lassis
cassia83714762c_assia
cassias93514342c_assias
chasses124017502chasses
clashes124017282clashes
clasps104512092cla_sps
class75525482cla_s_s
classed104113652classed
classer93614612classer
classers104111832classers
classico12386302classico
classier10359082classier
classiest11309542classiest
classify1644692classify
classily1336622classily
classing113211792classing
classisms13295522classisms
classists11296242classists
classon937692classon
classons1037702classons
classy11379042class_y
clastic113013962clastic
clastics122811412clastics
clasts84817292cla_sts
clauses93813322clauses
coassist10298802coassist
crasis85020472cra_sis
glasses84414272glasses
glassie8329492glassie
glassies94012272glassies
lasses64827592_lasses
lassi56316852_lassi_
lassie64917742_lassie
lassies74420102_lassies
lassos64913812_lassos
alaskas1136683alaskas
amasses93912853amasses
apsis75718293__apsis
arsis55722423__arsis
aspis74618143__aspis
assais6711963__assais
asses55629283__asses
assist6314603__assist
basis75429863_ba_sis
basses85428303_basses
bassi77019323_bassi_
bassist9312743_bassist
bassos85313703_bassos
biasses94911653biasses
blastie92411393blastie
blasties102113633blasties
blasts85116773bla_sts
blesses93812393blesses
blisses94911513blisses
brasses93818353brasses
brassie93411523brassie
brassies103613533brassies
brassish1346433brassish
caddis104613383c_addis
cadis84428503c_a_dis
calashes13310533calashes
calesas9411833calesas
camasses12388973camasses
cansos84915383c_ansos
capris10415083c_apris
capsid11312413c_apsid
capsids1239333c_apsids
carses85233653c_arses
casas75327843c_a_sas
caseic103212373c_aseic
casein83216453c_asein
caseins93115053c_aseins
cases75048383c_a_ses
cashes114729883c_ashes
casks115720063c_a_sks
cassina94113163c_assina
cassinas103610633c_assinas
cassine93817283c_assine
cassines103116613c_assines
cassino93512433c_assino
cassinos10309353c_assinos
cassises103811743c_assises
castes85631863c_astes
casts77237793c_a_sts
casuist9411303c_asuist
casus76419253c_a_sus
caulis85320083c_aulis
causes88026473c_auses
ceases84427073cea_ses
cesses84221363c_esses
chablis14368563chablis
chais107530313cha__is
chaises124317493chaises
challis124613463challis
chamois143512193chamois
chaoses124715123chaoses
chasers123714923chasers
chases115128233cha_ses
chasmic16177983chasmic
chasms135513143cha_sms
chasse115114603chass_e
chassed134712133chassed
chastise1348173chastise
chausses1345963chausses
chesses124112633chesses
cissies94116153c_issies
clachs133511323cla_chs
clacks144516343cla_cks
clades94920463cla_des
cladism1238553cladism
cladisms1336093cladisms
cladist10311973cladist
cladists1136723cladists
clads85722733cla__ds
clags85621123cla__gs
claim95616913cla__im
claims105211573cla_ims
clamors11710093clamors
clamps124515083cla_mps
clams95127673cla__ms
clangs95113613cla_ngs
clanks124615183cla_nks
clannish1345263clannish
clans75031013cla__ns
claps95626183cla__ps
claques18279013claques
clarets94111103clarets
claries93422203claries
clarkia1334873clarkia
clarkias1444793clarkias
claroes93113733claroes
claros84015113cla_ros
clash106219033cla_s_h
clashed133614013clashed
clasher124615513clasher
clashers134213993clashers
clashing143812193clashing
clasp95517193cla_s_p
clasped123610443clasped
clasper113811863clasper
claspers124410913claspers
clasping133310263clasping
claspt104513413cla_spt
classical1345293classical
classicals1443903classicals
classicism1664223classicism
classicist1445603classicist
classifies1555003classifies
classiness12196313classiness
classless1143843classless
clast76030583cla_s_t
clausal936273clausal
clause84311503claus_e
clavers124314903clavers
claves115020063cla_ves
clavi104912923cla_vi_
clavus11347353cla_vus
clawers123910973clawers
claws106020833cla__ws
claxons1635803claxons
clayish1547943clayish
clays105521333cla__ys
cleanses10358143cleanses
clevis1158963cl_evis
closers94415323closers
closes85425593cl_oses
closets94611603closets
coassists11275763coassists
coasts85719143coa_sts
coatis85122603coa_tis
colossi935673colossi_
colossus1045183colossus
crases85532313cra_ses
crashes124618403crashes
crass76328043cra_s_s
crasser94114333crasser
crassest103411523crassest
crassly1276653crassly
cresses94219813cresses
crisis83716343c_risis
crosses94220793crosses
cuisses9319883cuisses
cuspis105010703c_uspis
cusses84522773c_usses
cussos84210003c_ussos
cutlasses1145103cutlasses
cyanosis1346273cyanosis
cyesis1148573c_yesis
dalasis8810533dalasis
dashis104414393_dashis
dassie74615573_dassie
dassies84418663_dassies
declasses1246443declasses
eclipsis1243693eclipsis
ectasis9249613ecta_sis
elapses957663elapses
elastic93013393elastic
elastics102710883elastics
elastin72611843elastin
elastins82111743elastins
eyasses10388023eyasses
flashes133916103flashes
flasks13488673fla_sks
flosses103411973flosses
flossie10337443flossie
flossies112810123flossies
frasses104314513frasses
gasses75724783_gasses
glacis94012133gla_cis
glass65518133gla_s_s
glassed93710433glassed
glassier9289083glassier
glassiest10279243glassiest
glassily1235463glassily
glassine9329313glassine
glassines10278043glassines
glassing10329973glassing
glassy10527753glass_y
glossas8438193glossas
glosses84014123glosses
glossies93311253glossies
grasses84117343grasses
jassid1467223_jassid
jassids1586143_jassids
kolbassis1551413kolbassis
kvasses14365503kvasses
lanais6316793_lanais
lapis76223153_la_pis
lapses85217693_lapses
lapsus8437273_lapsus
laris54737463_la_ris
lasers64925703_lasers
lases54944763_la_ses
lashes94831003_lashes
lashins103915153_lashins
lass47444543_la_s_s
lasso55015683_lass_o
lassoes74613853_lassoes
lasts57731263_la_sts
lathis95516173_lathis
losses65925233_losses
lysis84511463_l_ysis
lyssas935443_lyssas
massas85116463_massas
masses85028713_masses
massif11412533_massif
massifs1237743_massifs
missis84417503_missis
molasses1037233molasses
myasis114010473mya_sis
oasis56422553_oa_sis
passes86030473_passes
passim10410283_passim
passus83610293_passus
pastis84924323_pastis
phasis114614923pha_sis
plashes124417393plashes
plasmas113010753plasmas
plasmic13249113plasmic
plasmid12239553plasmid
plasmids13236553plasmids
plasmin112410033plasmin
plasmins12199413plasmins
plasms103711333pla_sms
plastic112815063plastic
plastics122412333plastics
plastid102112523plastid
plastids11269213plastids
plisses94411773plisses
plusses93510693plusses
quasses16209503quasses
quassia1644793quassia
quassias1754933quassias
quassin1645943quassin
quassins1735793quassins
sasses64124393_sasses
sassies74719263_sassies
slashes103619103slashes
stasis63116873sta_sis
tasses64826763_tasses
tassie66017023_tassie
tassies74918933_tassies
trasses74819323trasses
tussis6379953_tussis
whatsis1335253whatsis
wrasses103812593wrasses

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.1531167915.0
2DLD Change Limit1340272946.97019229.1
3Display Results2942940.0933161.3
 (SQL Overall)1786912947.21624763.2
 
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.