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

122 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
squilla163553(None) 
squill1537231squill_
squillae1745191squillae
squillas1745331squillas
squills1666311squills
quill148413772_quill_
quillai1644992_quillai
quills153811852_quills
scilla8310942s_cilla
squall1538002squall_
squalls1647312squalls
squally1937672squally
ancilla948603ancilla
armilla936993armilla
axilla13289573_axilla
barilla9310333barilla
bulla74620563_bu_lla
cedilla1036343cedilla
coquille1944033coquille
equally1936873equally
gorilla836973gorilla
latilla737953latilla
manilla93012473manilla
maquila1844703maqui_la
maxilla16248193maxilla
megilla1036273megilla
mouille937843mouille
mulla74317113_mu_lla
papilla11127913papilla
perilla9311233perilla
qualia1559563_qualia
quelea1547303_quelea
quell144311433_quell_
quells15359703_quells
quillaia1743553_quillaia
quillais1745003_quillais
quillaja2442043_quillaja
quilled17329283_quilled
quillet162713233_quillet
quilt144125103_qui_lt
quilts154112543_quilts
quinela1635223_quinela
quinella1744053_quinella
quinoa15377653_quinoa
quinta153312373_quinta
quoll14379493_quoll_
quolls15327303_quolls
rouille737493rouille
salsilla844023salsilla
scillas9310473s_cillas
scull75315763scu_ll_
sculls84613883scu_lls
scutella1043553scutella
sedilia847243sedilia
sensilla845623sensilla
sequela1663993sequ_ela
sheila969843shei_la
shill85325333s_hill_
shills94519613s_hills
shrill94712303shrill_
shrills10389933shrills
shrilly13318563shrilly
sigla64515203s__igla
sill45545163s__ill_
sills55135993s__ills
silly84527623s__illy
silva82714023s__ilva
skill94316733s_kill_
skills104313923s_kills
skull94812033sku_ll_
skulls10429643sku_lls
spill74821163s_pill_
spills84717463s_pills
spirilla1045073spirilla
squalid1737053squalid
squalled1835943squalled
squaller1736083squaller
squalor1644423squalor
squama1736533squ_ama
squatly1946433squatly
squeal1538023squeal_
squeals1636513squeals
squelch2152953squelch
squib163710503squi__b
squibs17317453squi_bs
squid154211903squi__d
squids16409803squi_ds
squiffy2542573squiffy
squiggle1943183squiggle
squiggly2242503squiggly
squilgee1844623squilgee
squinch2134833squinch
squinny19274223squinny
squint154214793squi_nt
squints16339033squints
squinty19287063squinty
squire155912463squi_re
squired173710063squired
squires163812843squires
squirm17387673squi_rm
squirms18376343squirms
squirmy21374293squirmy
squirt153812933squi_rt
squirts16348013squirts
squish1838573squi_sh
squishy2244023squishy
stella63612973s_tella
still54922083s_till_
stills64118573s_tills
stilly93714093s_tilly
stull54916273stu_ll_
stulls63912983stu_lls
sulfa8313923s_u_lfa
sully84622903s_u_lly
swill83417373s_will_
swills94213363s_wills
tequila1644583tequi_la
tuille63012643_tuille
vanilla10238753vanilla
vexilla1744663vexilla
villa85321233__villa
zorilla1646023zorilla

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271226.15621771.8
3Display Results1221220.0304066.7
 (SQL Overall)1786911226.59227107.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.