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

102 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
thatchy183330(None) 
thatch1435611thatch_
catchy16559582_catchy
hatch135719592_hatch_
patchy16509572_patchy
snatchy15355292snatchy
tetchy1436002t_etchy
thatched1735432thatched
thatcher1635662thatcher
thatches1637512thatches
thearchy1943442thearchy
twitchy18393572twitchy
achy126316093__a_chy
anarchy1544933anarchy
apathy1437033apat_hy
batch124620103_batch_
beachy164011253bea_chy
bitchy16479203_bitchy
blotchy17293973blotchy
botchy16537823_botchy
branchy17357913branchy
catch125120373_catch_
chancy164010863chanc_y
chatchka22202893chatchka
chatchke22153883chatchke
chatty14419363chat_ty
chinchy20335513chinchy
churchy2044183churchy
clutchy17323893clutchy
cratch134110793cratch_
datcha1266563_datcha
deathy134210233deat_hy
dethatch1742753dethatch_
diarchy1644673diarchy
dyarchy1942503dyarchy
eparchy17204753eparchy
ethnarchy2051603ethnarchy
exarchy22193693exarchy
fitchy17437623_fitchy
glitchy16283083glitchy
hatched163414463_hatched
hatchel153510753_hatchel
hatcher153314723_hatcher
hatchery19326383_hatchery
hatches153420273_hatches
hatchet153317563_hatchet
hatchway2243293_hatchway
hath105933913_hat_h_
heathy156111213heat_hy
hitch134515473_hitch_
hotch136214733_hotch_
hutch135414093_hutch_
itchy13449013__itchy
klatch15445933klatch_
kvetchy2241803kvetchy
latch104620463_latch_
lathy115215063_lat_hy
leachy14419733lea_chy
match125621103_match_
natch105018223_natch_
nuthatch1642083nuthatch_
patch125221223_patch_
peachy164510843pea_chy
pitchy16479673_pitchy
poachy16388963poa_chy
ratch104221363_ratch_
rhatany1353693rhatany
scratchy1843653scratchy
sketchy1943053sketchy
slatch114510533slatch_
smutchy17193153smutchy
snatch114310603snatch_
starchy15286743starchy
stretchy1644083stretchy
swatch14549283swatch_
tach96132753t_a_ch_
tache106222373t_a_che
tachs105820933t_a_chs
tacky145617443t_a_cky
talcky15294723t_alcky
tatty84720183t_at_ty
teach105221123tea_ch_
techy135612013t__echy
thack144915173tha_c_k
thacks154311923tha_cks
that75639323that___
thataway1742953thataway
thatchers1744583thatchers
thatchier1743983thatchier
thatching1835143thatching
toothy12529693toot_hy
torchy14549533t_orchy
touchy145010503t_ouchy
tranche123312223tranche
trashy12509053tra_shy
triarchy1643613triarchy
twitch14406163twitch_
uncatchy1842563uncatchy
watch135617063_watch_
whacky21556493wha_cky
witchy17468593_witchy
wrathy15377853wrat_hy

Search took 7 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 Filter1786911340270.393454684.5
2DLD Change Limit1340271026.31021240.4
3Display Results1021020.0333090.9
 (SQL Overall)1786911026.73626527.8
 
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.