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

195 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
chase10512712(None) 
case65848081c_ase
cease75227651cease
chafe135117351chafe
chaise114916411chaise
chape125221141chape
chare105231981chare
chased125019291chased
chaser114918381chaser
chases115128231chases
chasm125518791chasm
chasse115114601chasse
chaste114617391chaste
chose105925401chose
phase104617211phase
abase76023482abase
base64847022_base
blase75524232blase
cade76443912c_ade
cafe95230322c_afe
cage75339062c_age
cake105439962c_ake
came87648752c_ame
cane66653122c_ane
cape87242782c_ape
care66968372c_are
carse74934332carse
casa65630862c_asa
cased86032412c_ased
cases75048382c_ases
cash96636282c_ash
cask105626432c_ask
cast67159902c_ast
caste75932362c_aste
cate66254602c_ate
cause75225352cause
cave95941262c_ave
ceased94920782ceased
ceases84427072ceases
cense75121402cense
chad105525502cha_d
chads116122232chads
chafed154813912chafed
chafer144714572chafer
chafes145017912chafes
chaff165016282chaff
chai95929902cha_i
chain105723672chain
chaine115119222chaine
chair105519632chair
chais107530312chais
chaises124317492chaises
chaleh143711992chaleh
chalet113825992chalet
chalk144814602chalk
cham115532312cha_m
chamise143612852chamise
champ145017962champ
chams126028502chams
chance134617092chance
chang115418562chang
change124116752change
chant105932692chant
chao95727312cha_o
chaos105622862chaos
chaoses124715122chaoses
chap114928492cha_p
chapel134911372chapel
chapes135421872chapes
chaps125326062chaps
chapt125827642chapt
char95132152cha_r
chard116124742chard
chared125423692chared
chares115631802chares
charge125114212charge
chark144222712chark
charm126124662charm
charr104821782charr
chars105936642chars
chart105038282chart
chary135023132chary
chasers123714922chasers
chasmed154710172chasmed
chasms135513142chasms
chasmy16468542chasmy
chassed134712132chassed
chasses124017502chasses
chasten124312402chasten
chaster124718502chaster
chat95546132cha_t
chats105730092chats
chaw126224632cha_w
chawed155214602chawed
chawer144314412chawer
chaws135022462chaws
chay124924872cha_y
chays135319742chays
cheese113812762cheese
chess105016922chess
chest104926142chest
chias104625522chias_
chiasm13449102chiasm
chide115321012chide
chile105626892chile
chime125322592chime
chine105231722chine
chis95933312chis_
chisel112111942chisel
chive135117622chive
choke145118022choke
choose115116142choose
chore105126762chore
chosen116014132chosen
choses115825132choses
chouse116017562chouse
chowse144711752chowse
chute104316462chute
chyle134913482chyle
chyme156512502chyme
clade85821012clade
clash106219032clash
clasp95517192clasp
class75525482class
clast76030582clast
clause84311502clause
clave105420152clave
close76425222close
coarse84813902coarse
coast75236272coast
copse95623932copse
corse75036182corse
crake114823522crake
crane75331602crane
crape96128442crape
crases85532312crases
crash109120012crash
crass76328042crass
crate76537402crate
crave105626312crave
craze165221462craze
crease85519572crease
cruse75726102cruse
curse75829142curse
ease45042332_ease
enchase1239462enchase
erase54925492erase
fease84824872fease
ghast95621222ghast
hade85440192_hade
hae67364002_ha_e
haes77651022_haes
hake115637842_hake
hale76052832_hale
hame97043132_hame
hanse85722792_hanse
hare76255732_hare
has67372652_has_
hash106936502_hash
hasp96627292_hasp
hast76259482_hast
haste85927862_haste
hate78450172_hate
have106137072_have
hawse116015122_hawse
haze164833392_haze
hose76547242_hose
lase46148512_lase
lease55230262lease
lyase85512412lyase
pase65346862_pase
pease75231112pease
phage115113672phage
phased124011972phased
phases114618402phases
phrase11109902phrase
prase76128752prase
rase46149982_rase
shade95125582shade
shake124726402shake
shale85332832shale
shame105726702shame
shape105125112shape
share86437082share
shave114425892shave
tease55428712tease
thae76825562tha_e
thane86122532thane
these86519012these
those85218142those
ukase9428492ukase
urase54624692urase
vase75629652_vase
whale115517432whale
whose114914532whose

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 Filter178691538000.326548131.9
2DLD Change Limit538001951.69031834.3
3Display Results1951950.0464239.1
 (SQL Overall)1786911952.06286659.1
 
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.