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

343 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
hic8654056(None) 
chic115925201chic
hi57947581hi_
hick135530301hick
hid76248361hid
hie67652701hie
him86247651him
hin67559561hin
hip86750431hip
his66359501his
hit66569191hit
huic94818051huic
mic77647631mic
pic76046821pic
sic55847871sic
tic56343461tic
ahi68040232ahi_
ahis76135382ahis
ai211288392ai_
aid49269072aid
ail37171042ail
aim57858212aim
ain37579092ain
air38058392air
ais39083572ais
ait38093902ait
arc510250902arc
bi48046462bi_
bib77045922bib
bice86235552bice
bid67751782bid
big67345712big
bin56658632bin
bio57846072bio
bis56860652bis
bit57070892bit
biz147939352biz
chi86228652chi_
chia96026622chia
chica125818262chica
chick165419132chick
chico124218252chico
chics123920942chics
chid106626402chid
chin96934742chin
chip116726422chip
chis95933312chis
chit96937462chit
cig67036182cig
cis57748032cis
dib65746932dib
dice75841892dice
dick116432382dick
did56850512did
die46759652die
dif76846892dif
dig57544472dig
dim68146492dim
din46459462din
dip67848982dip
dis46459892dis
disc76123232disc
dit47071332dit
doc66841512doc
emic86422742emic
epic86921302epic
ethic101511222ethic
etic66123952etic
fib86344262fib
fice95737112fice
fico95824582fico
fid76847682fid
fie67152442fie
fig76242832fig
fil65447142fil
fin66458032fin
fir66744892fir
fisc96819752fisc
fit66365452fit
fix136236102fix
fiz156238762fiz
flic96223732flic
ghi77019882ghi_
ghis85020162ghis
gib66443522gib
gid57047262gid
gie47149542gie
gig56040752gig
gin46055752gin
gip67645362gip
git46266052git
ha510259942h_a
hack135134542hack
had77658762had
hae67364002hae
hag77255742hag
hah910655222hah
haik115526982haik
hail74839062hail
hair76330142hair
haj138140602haj
ham86363282ham
hao67251122hao
hap87360052hap
has67372652has
hat67289962hat
haw97153272haw
hay97358772hay
he58151952h_e
heck135826492heck
heh96039622heh
heil76328932heil
heir77523802heir
hem86148732hem
hemic125718622hemic
hen67555272hen
hep86644142hep
her66547812her
hes66654202hes
het67674312het
hew97642722hew
hex137436172hex
hey96741062hey
hicks145322172hicks
hide85134622hide
hied85434042hied
hies74842832hies
high116619912high
hike116830392hike
hila76228352hila
hili75626632hili
hill76439492hill
hilt75850712hilt
hims95230972hims
hind85529752hind
hins76447992hins
hint77455742hint
hips96433702hips
hire75538962hire
hisn79620932hisn
hiss75629212hiss
hist76551542hist
hitch134515472hitch
hits75545132hits
hive106029672hive
hm78126732h_m
hmm106218992hmm
ho510258272h_o
hob87550922hob
hock136031302hock
hod76852462hod
hoe67562722hoe
hog78049062hog
hoick145210682hoick
hon67759382hon
hop87554592hop
hos68364192hos
hot67776052hot
how97252432how
hoy97447912hoy
hub86437482hub
huck135927632huck
hue66642302hue
hug76037362hug
huh96432012huh
hum85542932hum
humic124113242humic
hun65844712hun
hup86437812hup
hut66457292hut
hyp117822462hyp
ice56737242_ice
ich86227742_ich
ick97329322_ick
icy86322122_icy
id38941832_id
if57239942_if
in28150862_in
is27048212_is
it28455682_it
jib125835962jib
jig115633512jig
jin106443932jin
khi106318302khi_
khis117017982khis
ki67537952ki_
kick96026062kick
kid86540612kid
kif105941172kif
kin76353962kin
kip97042132kip
kir76535672kir
kis78051472kis
kit78559872kit
lac510155822lac
laic65931562laic
li29948752li_
lib57750262lib
lice66045062lice
lich96230842lich
lick106935072lick
lid47453512lid
lie38264522lie
lin37967372lin
lip514755802lip
lis37162272lis
lit39377312lit
mac78053922mac
mi48249042mi_
mib76946102mib
mica86428242mica
mice87442222mice
mick126333422mick
mics87435142mics
mid67354452mid
mig65646072mig
mil55752102mil
mim76048412mim
mir57046762mir
mis58162612mis
mix126138172mix
moc77845082moc
myc106519502myc
nib56745182nib
nice65534712nice
nick106627602nick
nil36144192nil
nim57142952nim
nip56945982nip
nit37065942nit
nix106932832nix
odic74920572odic
ohia75719362ohia
ohmic1237832ohmic
oi29061482oi_
oil37452052oil
orc57034922orc
otic66624812otic
pac79054082pac
pec76744412pec
phi86524202phi_
phis95724902phis
phiz186718842phiz
pi48145362pi_
pia56848032pia
pica85831492pica
pice84641092pice
pick125933812pick
pics85633912pics
pie55457402pie
pig65744972pig
pin57066722pin
pip78051042pip
pis56362032pis
pit56471922pit
piu56639542piu
pix126437932pix
pyic116915822pyic
qi116526902qi_
qis126934382qis
rec55645462rec
ria36745502ria
rib56848022rib
rice64942912rice
rich97025542rich
rick107334652rick
rid46754622rid
rif65951552rif
rig46748122rig
rim56052272rim
rin36663182rin
rip56851302rip
roc520243252roc
sac57452862sac
sec55945322sec
shim95827842shim
shin75634302shin
ship95228232ship
shit76745932shit
shiv105721162shiv
si29149572si_
sib56850302sib
sice65545592sice
sick106435572sick
sics65234092sics
sim56553132sim
sin36265892sin
sip57656012sip
sir35746672sir
sis37360542sis
sit35877752sit
six105339742six
spic85227432spic
thick145613352thick
thin76732382thin
thio77225412thio
thir76420542thir
this76027382this
ti28448292ti_
tick106231222tick
tics65729632tics
tie36557532tie
til36350262til
tin36362172tin
tip56551222tip
tis37056642tis
tit36771042tit
uric63624932uric
vac86537142vac
via65636242via
vice95732852vice
vid77241802vid
vie65447632vie
vig75637522vig
vim87437022vim
vis66747612vis
which163910082which
whid115418872whid
whig115516422whig
whim126220522whim
whin105225692whin
whip125521842whip
whir105519282whir
whit104834172whit
whiz195919942whiz
wich125724742wich
wick135726302wick
wig76740382wig
win66456292win
wis66552332wis
wit66563772wit
wiz156434152wiz
xi98128162xi_
xis106935332xis
yid76640822yid
yin67648732yin
yip87241172yip
zig136931902zig
zin125643772zin
zinc156819092zinc
zip146636222zip
zit126049992zit
zoic152316072zoic

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.0762351197.4
2DLD Change Limit140843430.72019561.1
3Display Results3433430.1103118.2
 (SQL Overall)1786913430.906197230.7
 
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.