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

277 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
spittle93792(None) 
skittle1135531skittle
spittles1038331spittles
brittle9168602brittle
cuittle946402cuittle
epistle957892epistle
kittle104012172_kittle
little63312162_little
pettle84116052_pettle
pintle83818262_pintle
pottle84416102_pottle
scuttle936462scuttle
settle63915662s_ettle
shuttle1046102shuttle
skittles1245762skittles
spatzle1834582spatzle
spicule11269932spicule
spile75230082spi__le
spindle103210092spindle
spinule9299992spinule
spital83813872spital_
spitals93011592spitals
spite75430662spi_t_e
spitted103912702spitted
spitter94015182spitter
sprattle1054762sprattle
spurtle937452spurtle
tittle63613322_tittle
vittle94711752_vittle
whittle13106102whittle
apostle937853apostle
battle85217863_battle
belittle1044053belittle
bottle84916073_bottle
brattle9249253brattle
bristle91910103bristle
brittled11186093brittled
brittler10165983brittler
brittles10178653brittles
brittly12165973brittly
cattle85118903_cattle
citole8311503_citole
cuittled1133993cuittled
cuittles1045903cuittles
cuttle84113893_cuttle
dottle74212503_dottle
entitle7610293entitle
epistler1044833epistler
epistles1047783epistles
epistyle1364073epistyle
epitome1157743epitome
epitope1147053epitope
espiegle1142603espiegle
fettle93713123_fettle
gristle8169223gristle
guttle74111973_guttle
intitle7610583intitle
istle52214713__istle
ixtle12168013__ixtle
kettle104311613_kettle
kirtle10309473_kirtle
kittel10368873_kittel
kittled12388193_kittled
kittler11338163_kittler
kittles113012493_kittles
littler7348553_littler
littles73212783_littles
mettle83815723_mettle
mottle84116053_mottle
nettle64514583_nettle
opiate8513463opiat_e
pattee84323383_pattee
pattie84020963_pattie
pestle83215843_pestle
pettled103611513_pettled
pettles93916483_pettles
pickle144215653_pickle
piddle103514913_piddle
piffle14418233_piffle
pile65649693_pi__le
pilule8411123_pilule
pimple123512963_pimple
pinole83218783_pinole
pintles94118723_pintles
piste75824603_pist_e
pistole92414313_pistole
pitta75018693_pitt_a
pittas86014523_pittas
pitted94319593_pitted
pizzle16279493_pizzle
pottles93816983_pottles
prattle9208833prattle
puttee85919723_puttee
puttie84116303_puttie
rattle64717613_rattle
retitle73913093retitle
saintly1039343saintly
saithe94713913sai_the
scottie937463scottie
scuttled1134533scuttled
scuttles1056503scuttles
sectile9311973sectile
settee63721023s_ettee
settled83210873s_ettled
settler73410653s_ettler
settles73916003s_ettles
sextile1438573sextile
shingle117711283shingle
shitake1455623shitake
shittah1385153shittah
shitted114212053shitted
shittier1137313shittier
shittim1245133shittim
shitty124110063shitt_y
shuttled1234673shuttled
shuttler1164903shuttler
shuttles1136553shuttles
sickle124418323s_ickle
sidle65124033s_i_dle
simile83115633s_imile
simple104315173s_imple
single74520603s_ingle
site47052413s_i_t_e
sitten64113823s_itten
sitter63323383s_itter
sixte126216583s_ixt_e
sizzle14309613s_izzle
skatole1135693skatole
skiable1338883skiable
skiffle17225203skiffle
skite95120053ski_t_e
skitter113810403skitter
slitted83513313slitted
slitter73615873slitter
slittier837003slittier
slitty9329163slitt_y
smile74823923smi__le
smite75224873smi_t_e
smitten936693smitten
sniffle13287653sniffle
sniggle9316833sniggle
sopite84917713sopi_t_e
spackle15369573spackle
spaetzle1942243spaetzle
spale74929213sp__ale
spangle1038403spangle
sparkle133710213sparkle
spate74731583sp_at_e
spathe115115693sp_athe
spatted104014143spatted
spatter94016523spatter
spatula935893spatula
spatzles1935303spatzles
speckle15297553speckle
spectre11297773spectre
spicae104313703spi_cae
spicate113214193spicate
spice95528813spi__ce
spicily1438653spicily
spicula11259293spicula
spiculae12218603spiculae
spicules12219803spicules
spiegel1034553spiegel
spiel74623913spi_el_
spieled104811883spi_eled
spieler93111233spi_eler
spiels85317953spi_els
spike114922843spi__ke
spikelet1446533spikelet
spikily1635873spikily
spiled94621993spi__led
spiles84227913spi__les
spill74821163spi__ll
spilled103613623spi_lled
spiller92914333spi_ller
spills84717463spi_lls
spilt75532223spi__lt
spilth11469733spilt_h
spilths12356023spilths
spinage10289653spinage
spinal84915313spinal_
spinals93911863spinals
spinate93114813spinate
spindled12287643spindled
spindler11297983spindler
spindles112710353spindles
spindly13257383spindly
spine76534423spi__ne
spinel85317333spinel_
spinelle1046223spinelle
spinels94512443spinels
spinose937943spinose
spinto8410663spint_o
spintos939133spintos
spinula9257903spinula
spinulae10276963spinulae
spinules10249333spinules
spiracle1255803spiracle
spiral83715343spiral_
spiraled1137733spiraled
spirals93212513spirals
spire75828693spi__re
spireme11478363spireme
spirt75032953spirt__
spirted103913073spirted
spirts85317133spirt_s
spirula9257703spirula
spirulae10216573spirulae
spit65545083spi_t__
spitball1244493spitball
spited94820443spi_ted
spites84127333spi_tes
spitfire1343053spitfire
spiting103917623spiting
spits74429553spi_t_s
spitters104113383spitters
spitting113012323spitting
spittlebug155703spittlebug
spittoon1042513spittoon
spitz166017973spi_t_z
spitzes1849183spitzes
splitter10348443splitter
sporule937273sporule
spottable1345343spottable
spotted103713143spotted
spotter94514883spotter
spottier10207313spottier
spottily1335153spottily
spotty11448583spott_y
sprattled1263313sprattled
sprattles1174883sprattles
sprinkle1434893sprinkle
sprite84421773sprit_e
spurtles1037783spurtles
sputter94014053sputter
stale55637103s__tale
startle72511123startle
stele55026843s__tele
stickle132410973stickle
stifle93611903sti_fle
stile54931573s__tile
stipple1146623stipple
stipule936723stipule
stole54928813s__tole
style85519363s__tyle
subtile91912623subtile
subtitle1046603subtitle
subtle82113433s_ubtle
suitable10310893suitable
suite54829563sui_t_e
surtitle845283surtitle
suttee63721543s_uttee
swiftlet1444793swiftlet
swiftly1633733swiftly
swindle11389183swindle
swingle113510563swingle
swiple11379233swi_ple
swipple1444633swipple
swithe124010683swi_the
swithly1634443swithly
swizzle1854103swizzle
systole1035763systole
tattle64115653_tattle
thistle10107803thistle
title54721073_ti_tle
tittie63213153_tittie
tittles73413253_tittles
twattle1064273twattle
vittae93911003_vittae
vittled11347343_vittled
vittles103211113_vittles
wattle94314213_wattle
whistle13107533whistle
whittled1594913whittled
whittler1495193whittler
whittles1496673whittles
wintle94014603_wintle

Search took 8 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.466383457.1
2DLD Change Limit1340272776.79619721.5
3Display Results2772770.1102518.2
 (SQL Overall)1786912777.37224239.1
 
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.