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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

103 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
classes9471794(None) 
chasses124017501chasses
clashes124017281clashes
classed104113651classed
classer93614611classer
classers104111831classers
classis93712721classis
clauses93813321clauses
glasses84414271glasses
lasses64827591_lasses
amasses93912852amasses
asses55629282__asses
basses85428302_basses
biasses94911652biasses
blesses93812392blesses
blisses94911512blisses
brasses93818352brasses
calashes13310532calashes
camasses12388972camasses
carses85233652c_arses
cases75048382c_a_ses
cashes114729882c_ashes
cassis84818852c_assis
castes85631862c_astes
causes88026472c_auses
ceases84427072cea_ses
cesses84221362c_esses
chaises124317492chaises
chaoses124715112chaoses
chases115128232cha_ses
chasse115114602chasse_
chassed134712132chassed
chassis123910662chassis
chausses1345962chausses
chesses124112632chesses
clades94920462cla_des
claques18279012claques
claries93422202claries
claroes93113732claroes
clashed133614012clashed
clasher124615512clasher
clashers134213992clashers
clasped123610442clasped
clasper113811862clasper
claspers124410912claspers
clasps104512092cla_sps
class75525482cla_s_s
classic113710112classic
classics12418872classics
classier10359082classier
classiest11309542classiest
classism12407172classism
classist104010382classist
classless1143842classless
classon937692classon
classons1037702classons
classy11379042class_y
clasts84817292cla_sts
clause84311502clause_
claves115020062cla_ves
cleanses10358142cleanses
closes85425592cl_oses
crases85532312cra_ses
crashes124618402crashes
crasser94114332crasser
crassest103411522crassest
cresses94219812cresses
crosses94220792crosses
cuisses9319882cuisses
cusses84522772c_usses
cutlasses1145102cutlasses
declasses1246442declasses
elapses957662elapses
eyasses10388022eyasses
flashes133916102flashes
flosses103411972flosses
frasses104314512frasses
gasses75724782_gasses
glassed93710432glassed
glassies94012272glassies
glosses84014122glosses
grasses84117342grasses
kvasses14365502kvasses
lapses85217692_lapses
lases54944762_la_ses
lashes94831002_lashes
lassies74420102_lassies
lassis65216702_lassis
lassoes74613852_lassoes
lassos64913812_lassos
losses65925232_losses
masses85028712_masses
molasses1037232molasses
passes86030472_passes
plashes124417392plashes
plisses94411772plisses
plusses93510692plusses
quasses16209502quasses
sasses64124392_sasses
slashes103619102slashes
tasses64826762_tasses
trasses74819322trasses
wrasses103812592wrasses

Search took 5 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 Filter1786911076710.1261418182.5
2DLD Change Limit1076711034.21625538.7
3Display Results1031030.0631634.9
 (SQL Overall)1786911034.40540565.5
 
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.