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

252 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
spilths1235602(None) 
spilth11469731spilth_
filths12389782_filths
piths105817542_pi_ths
silts55330822s_ilt_s
sixths16416372s_ixths
smiths114711022smi_ths
spelts84614642spelt_s
spiles84227912spil_es
spills84717462spil_ls
spilt75532222spilt__
spintos939132spintos
spirts85317132spirt_s
spites84127332spi_tes
spits74429552spi_t_s
splits85416412split_s
stilts67915312stilt_s
tilths9459372_tilths
airths95414253_airths
aplites9314933aplites
births115713603_births
briths115113863bri_ths
coolths1236013coolths
eoliths10318573eoliths
epilates10313503epilates
epilogs1076583epilogs
faiths124610273fai_ths
fifths15406543_fifths
filth115015823_filth_
filthy15356423_filthy
firths125113503_firths
friths124313583fri_ths
gilts64924263_gilt_s
girths105612273_girths
griths105211653gri_ths
guilts74111233guilt_s
healths13478753healths
hilts86924413_hilt_s
jilts124717413_jilt_s
kilts95122183_kilt_s
kiths125814973_ki_ths
lilts55822803_lilt_s
milts75430713_milt_s
mirths114912993_mirths
ninths936933_ninths
ooliths10268323ooliths
opiates9312143opiates
paths105521383_p_aths
pelts76128813_pelt_s
pietas84516503_pietas
pilafs113511023_pilafs
pilaus84114133_pilaus
pilaws11399433_pilaws
piles74742613_pil_es
pileus84514943_pileus
pilis75825203_pil_is
pills74130973_pil_ls
pilots84018873_pilots
pilous84717753_pilous
pilus75921063_pil_us
pintas85021393_pintas
pintos86021293_pintos
pints75936223_pint_s
pistes85325633_pistes
pitas77427673_pi_tas
pith95432693_pi_th_
pithy135614463_pi_thy
pits66348743_pi_t_s
pittas86014523_pittas
plinths1236123plinths
quilts154112543quilt_s
sailers73822323sailers
sailors73213723sailors
sails55738103sail__s
saints65122423saint_s
saith85826553sai_th_
saithe94713913sai_the
salts55431883s_alt_s
saults65816173sault_s
scillas9310473scillas
scouths12527893scouths
selahs9313213s_elahs
sheaths1358753sheaths
sheltas10279673sheltas
shibahs15275643shibahs
shifts124412943shift_s
shills94519613shil_ls
shirts94918343shirt_s
shists96515113shist_s
shits84731173shi_t_s
shittahs14114103shittahs
shivahs16375723shivahs
sifts84918923s_ift_s
sighs95416743s_i_ghs
sights103818013s_ights
silds65520523s_il_ds
silks94620683s_il_ks
sills55135993s_il_ls
silos56029433s_il_os
silt46558193s_ilt__
silted74020013s_ilted
silty84721633s_ilt_y
silvas92912183s_ilvas
sinhs86719603s_i_nhs
sites56045433s_i_tes
sith75435153s_i_th_
sits45050203s_i_t_s
situs55019233s_i_tus
sixtes133612403s_ixtes
sixth155512233s_ixth_
skills104313923skil_ls
skirts104111503skirt_s
skites104418043ski_tes
skits94721863ski_t_s
sleuths1034743sleuths
slights112810723slights
slits56128853sli_t_s
sloths94911893s_loths
smaltos9408193smaltos
smalts85214893smalt_s
smelts85412773smelt_s
smilers94113853smilers
smiles84522293smil_es
smileys12336323smileys
smites83921923smi_tes
smith107818053smi_th_
smithy14508273smi_thy
smolts84411883smolt_s
smooths12216323smooths
snaths95112913s_naths
snits54124833sni_t_s
soils55327983soil__s
sooths95715593s_ooths
sopites93817173sopi_tes
soths86218633s__oths
souths95216603s_ouths
spails84817823spail__s
spaits85017473spait_s
spales84728103spal_es
spalls84217343spal_ls
spates85028173sp_ates
spathe115115693sp_athe
spathes125116533sp_athes
spats75031383sp_at_s
speils84116223speil__s
spells84617683spel_ls
spelt75430193spelt__
spelter94113703spelter
spelters103912243spelters
speltz174010123spelt_z
speltzes1944003speltzes
spicas104715823spi_cas
spicers113815553spicers
spices104326033spi_ces
spicks144814993spi_cks
spics94123243spi__cs
spiders103914413spiders
spielers10319653spielers
spiels85317953spi_els
spiers84421743spi_ers
spies76037623spi__es
spiffs14328473spi_ffs
spigots1037793spigots
spikers135311993spikers
spikes124520713spi_kes
spiks114117473spi__ks
spile75230083spil__e
spiled94621993spil_ed
spiling102919703spiling
spilings11308813spilings
spill74821163spil__l
spilled103613623spilled
spiller92914333spiller
spillers103311703spillers
spinals93911863spinals
spinels94512443spinels
spines85132033spi_nes
spinets94714813spinets
spinless10238703spinless
spinors939423spinors
spinous9310443spinous
spins75327983spi__ns
spinto8410663spint_o
spirals93212513spirals
spireas94412513spireas
spirems11499563spirems
spires84628113spi_res
spirits94112623spirits
spirt75032953spirt__
spirted103913073spirted
spit65545083spi_t__
spital83813873spi_tal
spitals93011593spitals
spite75430663spi_t_e
spited94820443spi_ted
spitted103912703spitted
spitter94015183spitter
spitters104113383spitters
spittle937923spittle
spittles1038333spittles
spitz166017973spi_t_z
spitzes1849183spitzes
spivs105114243spi__vs
splash1168823sp_lash
splats84817303sp_lats
splays114910873sp_lays
splices113914383splices
spliffs1533563spliffs
splines94718893splines
splints94511743splints
split75729013split__
splosh1186543sp_losh
spoilers10238633spoilers
spoils84614533spoil__s
spoilt85016593spoilt__
sports84619183sport_s
spots74424113sp_ot_s
spouts85115113spout_s
sprats85819933sprat_s
sprights14167143sprights
sprints94113773sprint_s
sprites94220333sprites
sprits85122533sprit_s
spurts84814973spurt_s
stealths11104123stealths
stichs114511653sti_chs
stiles64328773stil_es
stills64118573stil_ls
stilt54831983stilt__
stilted83511473stilted
stints65119763stint_s
stithy12398213sti_thy
straths102711723straths
suints64617783suint_s
suites63727403sui_tes
suits55028053sui_t_s
swarths13537323swarths
swaths125312643s_waths
swifts12408173swift_s
swills94213363swil_ls
swith115917403swi_th_
swithe124010683swi_the
sylphs1435543s_ylphs
synths12377883s_ynths
tilth85515363_tilth_
tilts55325613_tilt_s
triliths1145953triliths
uptilts934733uptilt_s
wealths13365813wealths
widths1335123_widths
wilts85023503_wilt_s
yirths12639533_yirths

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.393454684.5
2DLD Change Limit1340272526.21621561.6
3Display Results2522520.0803150.0
 (SQL Overall)1786912526.68926714.2
 
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.