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

242 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
crassest10341152(None) 
crossest1012012121crossest
brashest133511762brashest
brasses93818352brasses_
brassiest11369712brassiest
chasses124017502chasses_
chastest1349702chastest
classes94717942classes_
classiest11309542classiest
classist104010382classist
coarsest1039162coarsest
coassist10298802coassist
crankest1438142crankest
crases85532312cra_ses_
crashes124618402crashes_
crasser94114332crasse_r
crassness1136212crassness
craziest19319922craziest
creasiest11229942creasiest
cresses94219812cresses_
cresset93319942cresse_t
cressets10309102cressets
crispest12177372crispest
crosses94220792crosses_
frasses104314512frasses_
grasses84117342grasses_
grassiest10309512grassiest
grossest93810092grossest
rashest103916872_rashest
trasses74819322trasses_
wrasses103812592wrasses_
amasses93912853amasses_
artsiest879653artsiest
assent65119953__assent
assert64922573__assert
asses55629283__asses_
assess65710463__assess
asset55932263__asse_t
assets65617663__assets
assist6314593__assist
basest84720493_ba_sest
basses85428303_basses_
basset85225383_basse_t
bassets96414823_bassets
bassett94213863_bassett
bassist9312733_bassist
biasses94911653biasses_
braggest1296533braggest
braises93818873braises_
brakiest143912243brakiest
brashes124518463brashes_
brashiest14359853brashiest
brassart1047503brassart
brassed103612373brasse_d
brassies103613533brassies_
brassish1346433brassish
bravest124211753bra_vest
brawest123810483bra_west
briskest14337803briskest
brisses94314313brisses_
bruskest14315903bruskest
cagiest102916433c_agiest
cakiest133215663c_akiest
calmest11312343c_almest
camasses12388973camasses_
carcasses1337463carcasses_
caresses10314063caresses_
carses85233653c_arses_
cases75048383c_a_ses_
cashes114729883c_ashes_
casket124820993c_aske_t
caskets133910173c_askets
cassena9287843c_assena
cassene93111543c_assene
cassette1047813c_assette
cassis84818853c_assis_
castes85631863c_astes_
casuist9411303c_asuist
causes88026473c_auses_
ceases84427073cea_ses_
cerastes101111093cerastes_
cesses84221363c_esses_
chaises124317493chaises_
chaoses124715113chaoses_
chariest13315503chariest
chases115128233cha_ses_
chasse115114603chasse__
chassed134712133chasse_d
chassepot1652503chassepot
chasseur1343433chasseur
chassis123910663chassis_
chausses1345963chausses_
chesses124112633chesses_
clashes124017283clashes_
classed104113653classe_d
classer93614613classe_r
classers104111833classers
classis93712723classis_
classism12407173classism
classists11296243classists
classless1143843classless
clauses93813323clauses_
clayiest1337913clayiest
closest94312533c_losest
coaliest10316223coaliest
coassists11275763coassists
coattest1038853coattest
cosiest93819853c_osiest
cosset84125863c_osse_t
cossets95014283c_ossets
crabbiest1535623crabbiest
crabmeat1445483crabmeat
cradles103114123cradles_
craftiest1436913craftiest
craggiest13116523craggiest
crakes124921813cra_kes_
crambes1339953crambes_
crampiest15268613crampiest
cranes84330753cra_nes_
crankiest1538823crankiest
crapes104727693cra_pes_
crappiest15267263crappiest
crashed134214203crashe_d
crasher124616153crashe_r
crashers134013223crashers
crasis85020473cra_sis_
crass76328043cra_s_s_
crassly1276653crass_ly
crates85736053cra_tes_
craves115825393cra_ves_
crawliest14187403crawliest
crazes174720133cra_zes_
crazies183413853crazies_
creakiest15238593creakiest
creamiest13248933creamiest
creases94020963creases_
creeses93914623creeses_
crepiest12310383crepiest
crescent12711043crescent
crest74632693cr___est
crevasses1444133crevasses_
crises84529433cr_ises_
crispiest13197423crispiest
croakiest15167173croakiest
crookest1436683crookest
crosscut1245253crosscut
crosse85216303crosse__
crossed105313893crosse_d
crosser95015463crosse_r
crossers103912693crossers
crosslet1049593crosslet
crosslets1145183crosslets
crossness1137093crossness
crudest104510333cr_udest
cruelest1059183cruelest
cruises93514443cruises_
cruses88127713cr_uses_
cruset84425093cr_use_t
crusets93811043cr_usets
crushes124215133crushes_
crustiest112410043crustiest
cuirasses1144373cuirasses_
cuisses9319883cuisses_
cusses84522773c_usses_
drabbest13295663drabbest
dresses83716173dresses_
dressiest1036823dressiest
drosses84513823drosses_
drossiest1036523drossiest
easiest72318773_easiest
erases64425403era_ses_
eyasses10388023eyasses_
falsest10310013_falsest
fastest102413723_fastest
frailest1139493frailest
fraises104215693fraises_
frankest1536963frankest
freshest143010583freshest
gashest114813413_gashest
gasses75724783_gasses_
gassiest93212523_gassiest
glasses84414273glasses_
glassiest10279243glassiest
grandest10311573grandest
grapiest112211923grapiest
grassed93812793grasse_d
grassless1034303grassless
gravest114011633gra_vest
grayest11489363gra_yest
greasiest10208563greasiest
grosses84517683grosses_
harasses11311033harasses_
harshest14310193harshest
hoarsest1137133hoarsest
iratest7312483ira_test
kvasses14365503kvasses_
lasses64827593_lasses_
masses85028713_masses_
massiest103314423_massiest
morasses1038903morasses_
passes86030473_passes_
praises94121103praises_
prases84429023pra_ses_
presses93523153presses_
prisses94816713prisses_
prissiest11178893prissiest
prosiest10416523prosiest
prosses94019513prosses_
quasses16209503quasses_
raciest92820013_raciest
raises64826543_raises_
rankest112713813_rankest
rarest65725483_ra_rest
rases55447213_ra_ses_
rashes95330153_rashes_
raspiest10311273_raspiest
rassles73513923_rassles_
rawest93615063_ra_west
reassert8313673reassert
reassess836513reassess
rosiest73919213_rosiest
russet6319433_russe_t
russets738163_russets
sasses64124393_sasses_
sassiest83413613_sassiest
sparsest1048813sparsest
strasses81311433strasses_
tasses64826763_tasses_
tasset65925313_tasse_t
tassets75012773_tassets
transect10410053transect
transept1048633transept
trapnest10310923trapnest
trashes104119253trashes_
trashiest123110633trashiest
tresses73719543tresses_
tressiest937883tressiest
trusses73813633trusses_
urases63723563ura_ses_
vastest102911513_vastest
wrasse9398773wrasse__
wrassles11376713wrassles_

Search took 10 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.1561145455.1
2DLD Change Limit1461622428.81316584.8
3Display Results2422420.1102200.0
 (SQL Overall)1786912429.07919681.8
 
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.