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

162 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
ceased9492078(None) 
cased86032411c_ased
cease75227651cease_
ceases84427071ceases
censed94016321censed
cessed94615611cessed
chased125019291chased
creased104315581creased
eased65430401_eased
feased105718711feased
leased74722881leased
teased74721151teased
abased96514992abased
based85331582_based
beaded104922422beaded
beaked135919492beaked
beamed115720732beamed
beaned95621472beaned
biased94012222biased
caged95426362c_aged
caked126128622c_aked
caned85838092c_aned
caped104931802c_aped
cared86050092c_ared
case65848082c_ase_
cases75048382c_ases
cashed125124352c_ashed
casked134815512c_asked
caused95117042caused
caved116227562c_aved
cawed116627062c_awed
ceded96118552ce_ded
ceiled94114952ceiled
celled94420322celled
cense75121402cense_
censer84516582censer
censes83721802censes
cerated103922472cerated
cered85227442ce_red
cesses84221362cesses
chafed154813912chafed
chared125423692chared
chase105127122chase_
chaser114918382chaser
chases115128232chases
chasmed154710172chasmed
chassed134712132chassed
chawed155214602chawed
cheated134416342cheated
cheesed133910682cheesed
clashed133614012clashed
clasped123610442clasped
classed104113652classed
clawed125115072clawed
clayed125013042clayed
cleaned103512002cleaned
cleansed11395932cleansed
cleared103612462cleared
cleated103417842cleated
cleaved134010482cleaved
closed95317962closed
coaled95022702coaled
coasted104015942coasted
coated94927032coated
coaxed165612512coaxed
craned96121652craned
craped116120522craped
crases85532312crases
crashed134214202crashed
crated94827772crated
craved125417772craved
crazed184714452crazed
creaked143413232creaked
creamed123913712creamed
crease85519572crease_
creaser94415722creaser
creases94020962creases
created104323442created
cursed94321252cursed
cussed94917122cussed
deaned84620452deaned
deashed123411302deashed
deaved114916552deaved
debased113310582debased
deceased1247712deceased
eared65139502_eared
ease45042332_ease_
easel54521112_easel
eases56041612_eases
eaved95924502_eaved
erased74816752erased
feared106320432feared
fease84824872fease_
feases95422922feases
feasted11310842feasted
feazed195112632feazed
fessed104515062fessed
geared85317742geared
greased93812392greased
headed114020472headed
healed105121442healed
heaped124516902heaped
hearsed113811402hearsed
heated104525592heated
heaved134717862heaved
jeaned143813462jeaned
jessed144112302jessed
lased65132342_lased
leaded84221542leaded
leafed105713872leafed
leaked114217702leaked
leaned73422542leaned
leaped94317772leaped
lease55230262lease_
leaser65322672leaser
leases65428112leases
leashed113211162leashed
leaved105719022leaved
lensed74015472lensed
measled10339302measled
meated94222402meated
mensed93916542mensed
messed95018182messed
neared75119802neared
peaced115818912peaced
peaked136117402peaked
pealed95322802pealed
pease75231112pease_
peasen84815952peasen
peases85229472peases
peised94817682peised
phased124011972phased
pleased103712072pleased
rased65033932_rased
reamed94326122reamed
reaped94122452reaped
reared75930012reared
reaved104523922reaved
reused75419562reused
seabed95017692seabed
sealed74328362sealed
seamed94823882seamed
seared75232842seared
seated75131052seated
seised74218122seised
sensed73918162sensed
teamed95418592teamed
teared75722152teared
tease55428712tease_
teasel63914982teasel
teaser65421522teaser
teases65426272teases
teated74924022teated
tensed74817832tensed
vealed103916322vealed
versed104515512versed
weaned103816152weaned
weasel93410522weasel
weaved133913482weaved
yeaned103813902yeaned
yeasted1138502yeasted
yessed104511162yessed

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 Filter178691825510.1101624463.6
2DLD Change Limit825511624.08020233.1
3Display Results1621620.0632571.4
 (SQL Overall)1786911624.25342015.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.