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

101 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
achy12631609(None) 
ache96829821ache
ashy107717351ashy
aah616252962aah_
aahs716428562aahs
ably99725132ably
aby810238062a_by
ace59656832ac_e
aced79540882aced
aces67645092aces
ached119227832ached
aches106132292aches
achoo10315082achoo
acid77533392acid
acidy117214892acidy
acme86924322acme
acne66625872acne
acre67330772acre
act59557842ac_t
acta69524802acta
acts66929862acts
acyl95314292acyl
aery77231682aery
agha87417302agha
agly86821802agly
ah513868792a_h_
aha611246642a_ha
ahi68040232a_hi
ahoy101919182ahoy
ahs68644822a_hs
airy75734152airy
alky115920342alky
ally76935642ally
ancho104515302ancho
any68440492a_ny
arch98628442arch_
archly1437352archly
army96624182army
arty77531312arty
ash67944602ash_
away108024222away
awny105919302awny
awry107619682awry
ay511773892a__y
bach116131392bach_
beachy164011252beachy
cache125122482cache
cagy106321992cagy
caky136222442caky
catchy16559582catchy
cavy125920002cavy
cay87155982_cay
chay124924872_chay
chi86228652_chi
coy810557552_coy
cry89726242_cry
dacha114812572dacha
dashy125612382dashy
duchy144310872duchy
each95530582each_
eche97520282eche
echo96615952echo
echt95722902echt
ich86227742ich_
ichs96214712ichs
icky136315752icky
icy86322122ic_y
itchy13449012itchy
jacky215412342jacky
lacey105820912lacey
lacy95829632lac_y
lathy115215062lathy
leachy14419732leachy
mach116134482mach_
mache125925302mache
macho126120152macho
machs125722562machs
mashy136016502mashy
nacho105414382nacho
ochry13346932ochry
pacey126720282pacey
pacha126518062pacha
pacy115328682pac_y
patchy16509572patchy
peachy164510842peachy
poachy16388962poachy
racy95825682rac_y
scry96017762scry
shy96728192_shy
tach96132752tach_
tache106222372tache
tachs105820932tachs
tacky145617442tacky
techy135612012techy
thy97022912_thy
vichy1639042vichy
wacky174714932wacky
washy145911842washy
why126920012_why
yacht13417392yacht
yechy16519082yechy

Search took 2 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 Filter178691298720.280638182.1
2DLD Change Limit298721010.79637527.6
3Display Results1011010.0137769.2
 (SQL Overall)1786911011.089164087.2
 
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.