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

154 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
wich12572474(None) 
ich86227741_ich
lich96230841lich
rich97025541rich
which163910081which
wick135726301wick
winch135016661winch
wish107228731wish
witch134517561witch
with105730471with
wych154011881wych
aitch105216162aitch
arch98628442arch
bach116131392bach
bice86235562bice
birch124914022birch
bitch125017762bitch
cinch124516242cinch
dice75841892dice
dick116432382dick
dish86328332dish
ditch115015092ditch
each95530582each
etch95419142etch
fice95737112fice
fiche134616742fiche
fichu134810662fichu
fico95824592fico
filch134813322filch
finch135416972finch
fish106926272fish
fitch134816872fitch
hic86540562hic_
hick135530302hick
high116619922high
hitch134515472hitch
ice56737242_ice
ichs96214712_ichs
ick97329322_ick
icy86322122_icy
inch95420822inch
itch95619172itch
kick96026062kick
kith115826352kith
laich105920712laich
lech96825442lech
lice66045062lice
lichi104412952lichi
licht104723492licht
lick106935072lick
loch95527132loch
lych126015762lych
mach116134482mach
mic77647642mic_
mica86428252mica
mice87442232mice
miche126219242miche
mick126333432mick
mics87435152mics
milch124413372milch
much115224032much
nice65534712nice
niche105016792niche
nick106627602nick
nigh85220662nigh
ouch95724632ouch
pech116125452pech
pic76046822pic_
pica85831492pica
pice84641092pice
pick125933812pick
pics85633912pics
pinch125619302pinch
pish96127912pish
pitch125018412pitch
pith95432692pith
rice64942912rice
rick107334652rick
sic55847872sic_
sice65545592sice
sick106435572sick
sics65234092sics
sidh86222982sidh
sigh85625892sigh
sinh76238042sinh
sith75435152sith
stich104117922stich
such96424812such
swish115114822swish
switch14458912switch
swith115917402swith
tach96132752tach
tech95925442tech
tic56343462tic_
tick106231222tick
tics65729632tics
twice104711122twice
twitch14406162twitch
vice95732852vice
vichy1639042vichy
wack135330912wack
wash106033812wash
watch135617062watch
wecht13415442wecht
weigh125412512weigh
welch134411492welch
wench136214782wench
whish144512922whish
wicca1247252wicca
wiches144418752wiches
wicks144619362wicks
wide85235402wide
width12310962width
wife105228022wife
wig76740382wi_g
wight123725572wight
wigs84931252wigs
wilco1039442wilco
wild85126512wild
wile75944372wile
will75737512will
wilt76246292wilt
wily106428812wily
wimp115521522wimp
win66456292wi_n
wince105220882wince
wind85533852wind
wine74953422wine
wing86339222wing
wink116435022wink
wino75933612wino
wins75949172wins
winy107034322winy
wipe94830282wipe
wire75839812wire
wiry106422832wiry
wis66552332wi_s
wise75737342wise
wisha114910852wisha
wisp97124072wisp
wiss75630542wiss
wist78049292wist
wit66563772wi_t
witchy17468592witchy
wite75443272wite
withe115220232withe
withy144813762withy
wits76044872wits
wive105931752wive
wiz156434152wi_z
wrick144013392wrick
yech127220532yech
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 Filter178691298720.0762351197.4
2DLD Change Limit298721540.82636164.6
3Display Results1541540.0503080.0
 (SQL Overall)1786911540.952187700.6
 
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.