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

198 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
ceases8442707(None) 
cases75048381c_ases
cease75227651cease_
ceased94920781ceased
censes83721801censes
cesses84221361cesses
chases115128231chases
crases85532311crases
creases94020961creases
eases56041611_eases
feases95422921feases
leases65428111leases
peases85229471peases
teases65426271teases
abases85720772abases
baases85218012baases
bases75644352_bases
beasts84519722beasts
beses75830722be_ses
biases84618432biases
cades85440732c_ades
cafes106426922c_afes
cages85936012c_ages
cakes116037672c_akes
camases114216342camases
cames97047312c_ames
canes75350372c_anes
capes95441922c_apes
cares77369182c_ares
carses85233652carses
casas75327842c_asas
case65848082c_ase_
caseases10410472caseases
cased86032412c_ased
cashes114729882c_ashes
casks115720062c_asks
castes85631862c_astes
casts77237792c_asts
casus76419252c_asus
cates75951872c_ates
causes88026472causes
caves105639702c_aves
cedes84927322ce_des
cees65941592ce__es
cense75121402cense_
censed94016322censed
censer84516582censer
censers94313902censers
census84310302census
cepes94424462ce_pes
cerastes101111092cerastes
cerates95428232cerates
ceres75540012ce_res
cerises94722252cerises
certes84623082certes
ceruses93716232ceruses
cess65326052ce_s_s
cessed94615612cessed
cetanes9315132cetanes
cetes75731102ce_tes
chafes145017912chafes
chaises124317492chaises
chaoses124715112chaoses
chapes135421872chapes
chares115631802chares
chase105127122chase_
chased125019292chased
chaser114918382chaser
chasers123714892chasers
chasms135513142chasms
chasse115114602chasse
chasses124017502chasses
cheeses123613102cheeses
chesses124112632chesses
choses115825122choses
clades94920462clades
clashes124017282clashes
clasps104512092clasps
class75525482clas_s
classes94717942classes
clasts84817292clasts
clauses93813322clauses
claves115020062claves
cleanses10358142cleanses
cleaves124111622cleaves
closes85425592closes
coasts85719132coasts
coaxes154715632coaxes
copses104922472copses
corses84433462corses
coses76949492c_oses
crakes124921812crakes
cranes84330752cranes
crapes104727692crapes
crashes124618402crashes
crasis85020472crasis
crass76328042cras_s
crates85736052crates
craves115825392craves
crazes174720132crazes
crease85519572crease_
creased104315582creased
creaser94415722creaser
creasers103612812creasers
creates95225172creates
creeses93914622creeses
cresses94219812cresses
crises84529432crises
cruses88127712cruses
curses85328272curses
cusses84522772cusses
cycases1437532cycases
cyeses11510122cyeses
deashes113313902deashes
deaves105319532deaves
debases103814132debases
deceases11410152deceases
degases93413102degases
ease45042332_ease_
eased65430402_eased
easel54521112_easel
easels65914552_easels
easies64126632_easies
easts57530322_easts
eaves85231992_eaves
ectases92911672ectases
erases64425402erases
erses55826802_erses
eses45336102_e_ses
esses56422972_esses
eyases94513682eyases
fease84824872fease_
feased105718712feased
feasts95116092feasts
feazes184514172feazes
fesses94820252fesses
gases65633992_gases
greases84816712greases
hearses104414532hearses
heaves124120302heaves
jesses135215952jesses
kvases13467102kvases
lases54944762_lases
lease55230262lease_
leased74722882leased
leaser65322672leaser
leasers74717842leasers
leashes103514402leashes
leasts64616412leasts
leaves94222382leaves
lenses64620892lenses
leses54930812le_ses
lyases95211872lyases
measles92412752measles
menses84222452menses
messes84924342messes
myases113711552myases
nesses64718322nesses
oases55330982_oases
pases75346502_pases
peaces106324082peaces
peages94321842peages
pease75231112pease_
peasen84815952peasen
peises84125042peises
perses85428062perses
phases114618402phases
pleases94515482pleases
prases84429022prases
rases55447212_rases
reales64934122reales
reaves94127572reaves
reuses66025522reuses
seises64026712seises
senses63923942senses
sepses84515882sepses
stases64225562stases
tease55428712tease_
teased74721152teased
teasel63914982teasel
teasels74311312teasels
teaser65421522teaser
teasers75317242teasers
tenses64722552tenses
texases1437572texases
ukases10358062ukases
uneases73316262uneases
upases84112902upases
urases63723562urases
ureases74416722ureases
vases84626262_vases
verses94223762verses
weasel93410522weasel
weasels10468502weasels
weaves123616372weaves
yeasts96413052yeasts
yeses85119322ye_ses
yesses93615812yesses

Search took 3 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 Filter178691825510.1101624463.6
2DLD Change Limit825511982.78329662.6
3Display Results1981980.0633142.9
 (SQL Overall)1786911982.95660450.3
 
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.