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

263 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
fitchy1743762(None) 
bitchy16479201bitchy
fitch134816871fitch_
itchy13449011_itchy
pitchy16479671pitchy
witchy17468591witchy
aitch105216162aitch_
bitch125017762bitch_
botchy16537822botchy
catchy16559582catchy
ditch115015092ditch_
fetch134913472fetch_
fiche134616742fi_che
fichu134810662fi_chu
filch134813322filch_
filthy15356422filthy
finch135416972finch_
fishy146011662fi_shy
fitchee152710782fitchee
fitches153516192fitches
fitchet153113562fitchet
fitchew18276802fitchew
fitly115114972fit_ly
flitch14928172flitch_
glitchy16283082glitchy
hitch134515472hitch_
itch95619172_itch_
kitschy1941982kitschy
litchi1137892litchi
patchy16509572patchy
pitch125018412pitch_
pithy135614462pit_hy
tetchy1436002tetchy
twitchy18393572twitchy
vichy1639042vi_chy
witch134517562witch_
withy144813762wit_hy
achy126316093__achy
aitches123014363aitches
batch124620103batch_
beachy164011253beachy
beechy16397503beechy
birch124914023birch_
bitched153212923bitched
bitchen14349733bitchen
bitchery18236563bitchery
bitches144117063bitches
bitchily1844533bitchily
bitsy104511303bit_sy
bitty106119173bit_ty
blotchy17293973blotchy
botch126717453botch_
bothy136713963bot_hy
bunchy16437463bunchy
butch125416543butch_
catch125120373catch_
chinchy20335513chinchy
cinch124516243cinch_
citify1437443citify
city95122623cit__y
clutchy17323893clutchy
conchy163710223conchy
cutch125116193cutch_
datcha1266563datcha
diarchy1644673diarchy
dicey114819333di_cey
dicky154816243di_cky
dicty115116293di_cty
dinghy14476963dinghy
dishy125712353di_shy
ditched143711903ditched
ditcher134012003ditcher
ditches133215713ditches
ditsy95612563dit_sy
ditty95019293dit_ty
ditzy186513283dit_zy
duchy144310873_duchy
dutch114713823dutch_
etch95419143_etch_
faith115620853fait_h_
faiths124610273fait_hs
fancy134615483fanc_y
farcy135217093farc_y
fatly115716803fat_ly
fatty115117413fat_ty
fetched163710473fetched
fetcher153510393fetcher
fetches153413893fetches
fetich1479693fetich_
fiacre1137623fiacre
fiaschi1542793fiaschi
fice95737113fi_c_e
fices106031163fi_ces
fiches145219533fi_ches
fichus14388113fi_chus
ficin103516723fi_cin
fickly18318533fickly
fico95824593fi_c_o
ficus105015493fi_cus
fiddly14328483fiddly
fiery114714793fi_ery
fifth145210923fifth_
fifthly1943093fifthly
fifths15406543fifths
fifty145211423fi_fty
fight124027093fi_ght
filched16307423filched
filcher15377793filcher
filches153410723filches
filly114424903fi_lly
filmy136114043fi_lmy
filth115015823filth_
filths12389783filths
finca104714503finc_a
fincas113512073fincas
finches153914193finches
finely123011563finely
finery124512883finery
finicky1943713finicky
finny114716753fi_nny
firmly1436663firmly
firry115713533fi_rry
firth115819533firth_
firths125113503firths
fisc96819753fisc__
fiscal1139333fiscal
fiscs105311883fisc_s
fish106926273fi_sh_
fit66365453fit___
fitchets16307413fitchets
fitchews19274773fitchews
fitful1256333fitful
fits76043463fit__s
fitted104716663fitted
fitter94120033fitter
fixity19427803fixity
fizzy199015083fi_zzy
flashy15498173flashy
fleche14299303fleche
flecky18387653flecky
fleshy15406283fleshy
fletch14388193fletch_
flinch144010103flinch_
flitched17256293flitched
flitches16388463flitches
flocky18468423flocky
forwhy1834423forwhy
frith115922033frit_h_
friths124313583frit_hs
frothy15578373frothy
glitch12286353glitch_
gotcha1234633gotcha
hatch135719593hatch_
hitched163312253hitched
hitcher153712003hitcher
hitches153616273hitches
hotch136214723hotch_
hutch135414093hutch_
ich86227743_i_ch_
ichs96214713_i_chs
icky136315753_i_cky
icy86322123_i_c_y
inch95420823_inch_
itched123812023_itched
itches114916213_itches
itchily1574493_itchily
jitney16304623jitney
ketch144912023ketch_
kicky135012333ki_cky
kimchi1743803kimchi
kitchen16287683kitchen
kith115826353kit_h_
kithe125917453kit_he
kiths125814973kit_hs
kitsch1533353kitsch_
kitty124614563kit_ty
kvetchy2241803kvetchy
latch104620463latch_
lathy115215063lat_hy
leachy14419733leachy
letch105215803letch_
lich96230843li_ch_
lichi104412953li_chi
licht104723493li_cht
litany939053litany
litchis1238373litchis
lithe84922013lit_he
litho86513783lit_ho
match125621103match_
miche126219243mi_che
milch124413373milch_
mincy125817413minc_y
mity95528203mit__y
mothy136214553mot_hy
mutch125016173mutch_
mythy16568673myt_hy
natch105018223natch_
niche105016793ni_che
nitchie1247233nitchie
nitery94412173nitery
nitty85418313nit_ty
notch105613323notch_
outcry1137993outcry
patch125221223patch_
peachy164510843peachy
picky165416943pi_cky
pinch125619303pinch_
pitched153512923pitched
pitcher143813713pitcher
pitches143617753pitches
pitchily1855013pitchily
pith95432693pit_h_
piths105817543pit_hs
pity96031933pit__y
poachy16388963poachy
pouchy16538663pouchy
punchy16398523punchy
quitch2036413quitch_
ratch104221363ratch_
reechy14367823reechy
retch104818303retch_
rich97025543ri_ch_
richly1438003ri_chly
ritzy175611163rit_zy
rotch105815933rotch_
rotche114311983rotche
sitcom1036893sitcom
sith75435153sit_h_
sketchy1943043sketchy
smithy14508273smit_hy
smutchy17193153smutchy
snatchy15355293snatchy
snitch11357943snitch_
stich104117923stich_
stichs114511653stichs
sticky154711343sticky
stitch11419103stitch_
stithy12398213stithy
switch14458913switch_
techy135612013_techy
thatchy1833303thatchy
thy97022913__t_hy
tithe85319703tit_he
titty85316653tit_ty
torchy14549533torchy
touchy145010503touchy
twitch14406163twitch_
vetch134411843vetch_
watch135617063watch_
wich125724743wi_ch_
wincey144110383wincey
winch135016663winch_
witched163012193witched
witchery19236093witchery
witches152715793witches
with105730473wit_h_
withe115220233wit_he
witney12356843witney
witty114717013wit_ty
yechy16519083_yechy
zilch19438123zilch_
zincky24404963zincky
zincy195413513zinc_y

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 Filter1786911127160.1401276364.3
2DLD Change Limit1127162636.06318590.8
3Display Results2632630.1561685.9
 (SQL Overall)1786912636.35928100.5
 
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.