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

148 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
spinula925790(None) 
spicula11259291spicula
spinulae10276961spinulae
spinule9299991spinule
spirula9257701spirula
pinnula934922_pinnula
spatula935892spatula
specula11187412specula
spiculae12218602spiculae
spicular12238902spicular
spicule11269932spicule
spinal84915312spinal_
spinals93911862spinals
spindle103210092spindle
spindly13257382spindly
spinel85317332spinel_
spinels94512442spinels
spinules10249332spinules
spirulae10216572spirulae
spirulas10207202spirulas
acicula11228133acicula
apiculi1145113apiculi
cannula937433cannula
canula8312963_canula
capitula1244983capitula
cingula10327173_cingula
fibula11258053_fibula
frenula1045623frenula
ligula7359673_ligula
lingula8428803_lingula
lunula636173_lunula
papula103011113_papula
penult8314653_penult
picul95015363_picul_
piculs103511753_piculs
pilular938203_pilular
pilule8411123_pilule
pina65842643_pin__a
pinata83817223_pinata
pineal84817693_pineal
pineta85815563_pineta
pinkly155012243_pinkly
pinna75320183_pin_na
pinnal84814283_pinnal
pinnulae1044183_pinnulae
pinnular1044433_pinnular
pinnule936003_pinnule
pinole83218783_pinole
pinta75727053_pin_ta
pintle83818263_pintle
pinup9612883_pinu_p
pinups1037413_pinups
planula935773planula
primula1145713primula
pula65129373_p__ula
quinela1635223quinela
ranula6311813_ranula
retinula845723retinula
saintly1039343saintly
scapula1136343scapula
scilla8310943sci_lla
scopula1154993scopula
shingle117711283shingle
shingly143210813shingly
shinily13268933shinily
sigla64515203s_i_gla
silicula1065393silicula
simular938673s_imular
sinful938803s_inful_
single74520603s_ingle
singly104015853s_ingly
singular9327563s_ingular
sinus55523853s_inu_s
skinful1444193skinful_
skinfuls1543093skinfuls
spangle1038403spangle
spangly1336473spangly
spansule1043623spansule
spatular1044653spatular
spatulas1045473spatulas
specular12217613specular
spica94717943spi__ca
spicily1438653spicily
spiculate132210163spiculate
spicules12219803spicules
spiculum1464213spiculum
spiel74623913spi_el_
spiels85317953spi_els
spikily1635873spikily
spile75230083spi__le
spill74821163spi__ll
spills84717463spi_lls
spilt75532223spi__lt
spin66231303spin___
spinach1435403spinach
spinage10289653spinage
spinally1338023spinally
spinate93114813spinate
spindled12287643spindled
spindler11297983spindler
spindles112710353spindles
spine76534423spin__e
spined95423943spin_ed
spinelle1046223spinelle
spines85132033spin_es
spinet85629753spin_et
spinets94714813spinets
spinier93715163spinier
spinner93912263spinner
spinney12438923spinney
spinny114510183spin_ny
spinoff1544933spinoff
spinor839943spin_or
spinors939423spinors
spinose937943spinose
spinous9310443spinous
spinout9311583spinout
spinouts1036023spinouts
spins75327983spin__s
spinto8410663spin_to
spintos939133spintos
spinulose1142913spinulose
spiny104921303spin__y
spiraea9407983spiraea
spiral83715343spiral_
spirals93212513spirals
spirea84015633spi_rea
spirilla1045073spirilla
spirulina1143423spirulina
spital83813873spital_
spitals93011593spitals
spittle937923spittle
sponsal946343sponsal
sporular1065223sporular
sporule937273sporule
springal1145973springal
sprinkle1434893sprinkle
sputa74612963sp__uta
stimuli944513stimuli
stipular1045843stipular
stipule936723stipule
supinely1376293supinely
swindle11389183swindle
swingle113510563swingle
synura935983s_ynura
veinule1056243veinule
vincula1246403_vincula
zonula1537223_zonula

Search took 9 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.436409841.7
2DLD Change Limit1340271488.29616155.6
3Display Results1481480.0463217.4
 (SQL Overall)1786911488.77820356.7
 
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.