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

279 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
squill153723(None) 
quill148413771_quill
squall1538001squall
squilla1635531squilla
squills1666311squills
quell144311432_quell
quills153811852_quills
quilt144125102_quilt
quoll14379492_quoll
scull75315762scu_ll
shill85325332s_hill
shrill94712302shrill
sill45545152s__ill
skill94316722s_kill
skull94812032sku_ll
spill74821162s_pill
squalls1647312squalls
squally1937672squally
squeal1538022squeal
squib163710502squi_b
squibs17317452squibs
squid154211902squi_d
squids16409802squids
squillae1745192squillae
squillas1745332squillas
squint154214792squint
squire155912462squire
squirm17387672squirm
squirt153812932squirt
squish1838572squish
still54922082s_till
stull54916272stu_ll
swill83417372s_will
ahull84010313ahu_ll
asquint16208323asquint
bill67239943__bill
brill74819953_brill
build84413353_build
built74325923_built
bull65634873_bu_ll
chill105619873_chill
coquille1944033coquille
cull65929643_cu_ll
dill55239973__dill
drill64718263_drill
dull56430443_du_ll
equal1449823equ_al
equally1936873equally
equals1538693equals
equid154610323equi_d
equids16439143equids
equine151711573equine
equip16467263equi_p
equips17387193equips
equity1838103equity
esquire16376603esquire
fill75540193__fill
frill84917563_frill
full75229153_fu_ll
gill56336183__gill
gluily10308293gluily
grill64617893_grill
guild75312753_guild
guile64521133_guile
guilt65125573_guilt
gull54828453_gu_ll
hill76439493__hill
hull75428783_hu_ll
ill37437093___ill
infill938413infill
jill116430263__jill
kill85533183__kill
krill94213643_krill
lull44225763_lu_ll
maill74420793_maill
maquila1844703maquila
mill66541483__mill
mouille937843mouille
mull65128803_mu_ll
nill45634303__nill
null45125313_nu_ll
pasquil1843923pasqui_l
pasquils1943123pasquils
pill65339463__pill
prill74117943_prill
pull64731663_pu_ll
quail144314363_quail
quails153412643_quails
quale143617853_quale
qualm163511183_qualm
quells15359703_quells
quick204311063_quick
quid144922353_qui_d
quids154917463_quids
quiet144530733_quiet
quiff201111563_quiff
quillai1644993_quillai
quilled17329283_quilled
quillet162713233_quillet
quilts154112543_quilts
quin135823923_qui_n
quinol15357973_quinol
quins144819853_quins
quint144529903_quint
quip154818623_qui_p
quips164713373_quips
quipu164811643_quipu
quire144917133_quire
quirk184011003_quirk
quirt144624233_quirt
quit136136513_qui_t
quite144621463_quite
quits144122353_quits
quiz224920003_qui_z
quolls15327303_quolls
rebill84713253rebill
refill94514053refill
rill45140903__rill
rouille737493rouille
sail45447163s_ai_l
sails55738103s_ails
sall44544683s__all
samiel8313333samiel
saucily1237913saucily
saul45836523sau__l
sauls55128123sau_ls
sault55834963sau_lt
saurel6511993saurel
sawbill1255293sawbill
sawmill1244073sawmill
scall74420373s_call
scilla8310943s_cilla
scroll8310173scroll
sculk115112463scu_lk
sculls84613883sculls
sculp95314843scu_lp
sedile73517233sedile
sell45840613s__ell
senile63420213senile
sequel1556713sequ_el
sequela1663993sequela
sequels1665703sequels
sequin1538523sequi_n
sequins1637863sequins
serial64625863serial
sexily1638853sexily
shall85024053s_hall
sheila969843sheila
shell84424123s_hell
shiel811023773s_hiel
shills94519613s_hills
shily115222013s_hily
shrills10389933shrills
shrilly13318563shrilly
shul75823153shu__l
shuln84713113shu_ln
shuls85319713shu_ls
sial45938833s__ial
sigil63515503sigi_l
sigils73912363sigils
sild55030583s__ild
silk85529323s__ilk
sills55135993s__ills
silly84527623s__illy
silo46037913s__ilo
silt46558193s__ilt
simile83115633simile
skell94915833s_kell
skills104313923s_kills
skirl96012913s_kirl
skulk8479623sku_lk
skulls10429643skulls
slily85820033s_lily
sluice849513sluice
sluicy1166483sluicy
sluing74315883sluing
small74016263s_mall
smell74916233s_mell
smile74823923s_mile
smugly1274833smugly
snail57020203snai_l
snails64816653snails
snell54517303s_nell
snugly1055663snugly
social8813333social
soil46138833s_oi_l
soils55327983s_oils
soul46435713sou__l
souls55127363sou_ls
sourly93612213sourly
spail74921553spai_l
spails84817823spails
spall74919303s_pall
speil75618643spei_l
speils84116223speils
spell75020303s_pell
spiel74623913s_piel
spile75230083s_pile
spills84717463s_pills
spilt75532223s_pilt
spoil75818653spoi_l
spoils84614533spoils
spoilt85016593spoilt
spuing94313363spuing
squab163810733squ_ab
squabs17429323squabs
squad155110793squ_ad
squads164410293squads
squalid1737053squalid
squalled1835943squalled
squaller1736083squaller
squalor1644423squalor
squama1736533squama
square154513363square
squark19438113squark
squash1846833squash
squat143720143squ_at
squatly1946433squatly
squats153712963squats
squaw17368983squ_aw
squawk22385373squawk
squaws18438783squaws
squeak1935253squeak
squeals1636513squeals
squeg1588033squ_eg
squegs1675643squegs
squelch2152953squelch
squiffy2542573squiffy
squiggle1943183squiggle
squiggly2242503squiggly
squilgee1844623squilgee
squinch2134833squinch
squinny19274223squinny
squints16339033squints
squinty19287063squinty
squired173710063squired
squires163812843squires
squirms18376343squirms
squirmy21374293squirmy
squirrel17414533squirrel
squirts16348013squirts
squishy2244023squishy
squush1833993squush
stall54722353s_tall
stile54931573s_tile
stills64118573s_tills
stilly93714093s_tilly
stilt54831983s_tilt
stroll6311603stroll
studly10397693studly
stulls63912983stulls
suing65026363s_uing
suint55638183s_uint
suit45649873s_ui_t
suite54829563s_uite
suits55028053s_uits
sulk85326653s_u_lk
sully84622903s_ully
sulu45128423s_u_lu
sural55931263s_ural
surly85124433s_urly
swail86217163swai_l
swails94913123swails
swell84815983s_well
swills94213363s_wills
swirl84514143s_wirl
tequila1644583tequila
thill85918733_thill
thrill94910593thrill
till45941203__till
trill55122933_trill
trull54012673tru_ll
tuille63012643_tuille
twill85612723_twill
uphill11106173uphill
vill75235073__vill
will75737513__will
yill75628973__yill
zill135727613__zill

Search took 6 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.373479064.3
2DLD Change Limit1127162794.62624365.8
3Display Results2792790.0803487.5
 (SQL Overall)1786912795.07935182.3
 
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.