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

166 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
ich8622774(None) 
ice56737241ice
ichs96214711ichs
ick97329321ick
icy86322121icy
inch95420821inch
itch95619171itch
lich96230841lich
rich97025541rich
wich125724741wich
aah616252962aah
ace59656832ace
ache96829822ache
achy126316092achy
act59557842act
ah513868792_ah
aitch105216162aitch
arch98628442arch
ash67944602ash
bach116131392bach
bah87755352bah
bice86235552bice
birch124914022birch
bitch125017762bitch
chi86228652_chi
cig67036182cig
cinch124516242cinch
cis57748032cis
dah78148982dah
dice75841892dice
dick116432382dick
dish86328332dish
ditch115015092ditch
duh77930382duh
each95530582each
eche97520282eche
echo96615952echo
echt95722902echt
ecu56828232ecu
edh76921562edh
eh58339962_eh
etch95419142etch
eth66630982eth
feh96136092feh
fice95737112fice
fiche134616742fiche
fichu134810662fichu
fico95824592fico
filch134813322filch
finch135416972finch
fish106926272fish
fitch134816872fitch
foh98135892foh
hah910655222hah
heh96039622heh
hic86540562hic_
hick135530302hick
high116619912high
hitch134515472hitch
huh96432012huh
iced78721892iced
ices66129642ices
ichor1039472ichor
icky136315752icky
icon66922042icon
id38941832i_d
ids47535462ids
if57239942i_f
iff96730382iff
ifs67124242ifs
igg57116792igg
ilk78325302ilk
ill37437092ill
imp76626962imp
in28150862i_n
ink76433632ink
inn36727432inn
ins35945602ins
ion36051022ion
ire36943172ire
irk76426362irk
is27048212i_s
ism56322382ism
it28455682i_t
itchy13449012itchy
its35538832its
ivy96317442ivy
kick96026062kick
kith115826352kith
laich105920712laich
lech96825442lech
lice66045062lice
lichi104412952lichi
licht104723492licht
lick106935072lick
loch95527132loch
lych126015762lych
mach116134472mach
mic77647632mic_
mica86428242mica
mice87442222mice
miche126219242miche
mick126333422mick
mics87435142mics
milch124413372milch
much115224032much
nah69847002nah
nice65534712nice
niche105016792niche
nick106627602nick
nigh85220662nigh
noh66640642noh
nth66320592nth
oca56731732oca
oh57447002_oh
ooh67637092ooh
ouch95724632ouch
pah88853592pah
pech116125452pech
peh86740962peh
pic76046822pic_
pica85831492pica
pice84641092pice
pick125933812pick
pics85633912pics
pinch125619302pinch
pish96127912pish
pitch125018412pitch
pith95432692pith
poh86740532poh
rah68052402rah
rice64942912rice
rick107334652rick
sh56828522_sh
shh97121072shh
sic55847872sic_
sice65545592sice
sick106435572sick
sics65234092sics
sidh86222982sidh
sigh85625892sigh
sinh76238042sinh
sith75435152sith
stich104117922stich
such96424812such
tach96132752tach
tech95925442tech
tic56343462tic_
tick106231222tick
tics65729632tics
ugh76520682ugh
uh57429852_uh
vice95732852vice
vichy1639042vichy
which163910082which
wick135726302wick
winch135016662winch
wish107228732wish
witch134517562witch
with105730472with
wych154011882wych
yah99046352yah
yech127220532yech
yeh97135772yeh
yuch125818532yuch
zilch19438122zilch

Search took 1 second 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 Filter178691140840.0632836365.1
2DLD Change Limit140841660.42033533.3
3Display Results1661660.0335030.3
 (SQL Overall)1786911660.516346300.4
 
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.