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

250 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
spigots103779(None) 
spigot9312601spigot_
bigots95015132_bigots
epigons1048182epigons
gigots83911952_gigots
picots104616442_picots
pigouts1037592_pigouts
pilots84018872_pilots
pinots85920272_pinots
pivots115111902_pivots
sights103818012s_ights
slights112810722slights
spinets94714812spinets
spinors939422spinors
spinous9310442spinous
spinouts1036022spinouts
spintos939132spintos
spirits94112622spirits
spirts85317132spi_rts
spits74429552spi__ts
spots74424112sp__ots
sprights14167142sprights
alights113211433alights
amigos94511213amigo_s
apricots1275393apricots
argots74116033_argots
bights124417963_bights
bigos85020013_bigo_s
bigot84828323_bigot_
blights133110213blights
brights133710233brights
chigoes1338353chigoes
copilots1255753copilots
dicots94915793_dicots
dights114016963_dights
digits84114533_digits
diglots9299503_diglots
divots104712203_divots
eights103618983_eights
epidote1037393epidote
epidotes1147023epidotes
epigeous1146533epigeous
epigon937963epigo_n
epigone1057843epigone
epigones1138023epigones
epigoni1056093epigoni
epigonus1144423epigonus
epilogs1076583epilogs
ergots74512373_ergots
faggots1234863faggots
fagots1039963_fagots
fights133816553_fights
flights143310983flights
frights14339623frights
giglots9367863_giglots
gigot74023073_gigot_
griots74713643gri_ots
heights14399443heights
hights133716893_hights
idiots768643idi_ots
ingots7912063_ingots
knights1545653knights
lights104519913_lights
maggots1136563maggots
magots9312363_magots
mights123516253_mights
nights104117723_nights
pagods105310193_pagods
phots105418503_p_hots
picot95031013_picot_
pigboats1344523_pigboats
pigeons1039183_pigeons
piglets103311793_piglets
pignus937953_pignus
pignuts1035613_pignuts
pigout9314613_pigout
pigs76634223_pig__s
pigsty1235933_pigsty
pilot77435063_pilot_
pilous84717753_pilous
pingoes105116523_pingoes
pingos95317673_pingo_s
pinons86019943_pinons
pinot78737293_pinot_
pintos86021293_pintos
pints75936223_pi_nts
pions75826393_pi_ons
pious74621273_pi_ous
pipets105714773_pipets
pipits104713063_pipits
pisos76021063_piso_s
pitons85319043_pitons
pits66348743_pi__ts
pivot106523873_pivot_
plights13299313plights
plots75025673_p_lots
pots66452363_p__ots
rights104019333_rights
rigors72813713_rigors
riots54922013_ri_ots
sabots8314703s_abots
sagos66123873s_ago_s
saigas74114293saig_as
sailors73213723sailors
saints65122423sai_nts
sapients1037423sapients
sargos74318273sargo_s
scions82612243sci_ons
scoots85315943s_coots
scots74025913s__cots
segos64919483s_ego_s
seisors73212843seisors
seizors16329013seizors
serpigoes1243783serpigoes
serpigos1143843serpigo_s
sexpots1636293sexpots
shifts124412943shi_fts
shirts94918343shi_rts
shists96515113shi_sts
shits84731173shi__ts
shoots94619363s_hoots
shots84730853s__hots
sifts84918923s_i_fts
sighs95416743s_ig_hs
sight94629293s_ight_
sigils73912363s_igils
siglos7311473s_iglos
sigmas94111363s_igmas
signets83311503s_ignets
signors83410913s_ignors
signs65516323s_ig_ns
silos56029433s_ilo_s
silts55330823s_i_lts
siphons1239353siphons
sippets113310183sippets
sits45050203s_i__ts
skibobs1542993skibobs
skidoos1234463skidoos
skimos12548803skimo_s
skirts104111503ski_rts
skits94721863ski__ts
sleights12275913sleights
slight103416003slight_
slipouts1044893slipouts
slits56128853sli__ts
slots54830533s__lots
sniglets9276813sniglets
snits54124833sni__ts
snoots64216683s_noots
snots55225123s__nots
soots55536213s__oots
sorgos74514663sorgo_s
sots45552453s___ots
spaits85017473sp_aits
spambots1443313spambots
spats75031383sp__ats
spelts84614643sp_elts
spicas104715823spi_cas
spicate113214193spicate
spicers113815553spicers
spices104326033spi_ces
spicks144814993spi_cks
spics94123243spi__cs
spiders103914413spiders
spiegels1133873spiegels
spiels85317953spi_els
spiers84421743spi_ers
spies76037623spi__es
spiffs14328473spi_ffs
spikers135311993spikers
spikes124520713spi_kes
spiks114117473spi__ks
spiles84227913spi_les
spills84717463spi_lls
spilt75532223spi_lt_
spilth11469733spi_lth
spilths12356023spilths
spinals93911863spinals
spinate93114813spinate
spinels94512443spinels
spines85132033spi_nes
spinet85629753spinet_
spinoff1544933spinoff
spinoffs1642773spinoffs
spinor839943spino_r
spinose937943spinose
spinout9311583spinout
spins75327983spi__ns
spinto8410663spi_nto
spirals93212513spirals
spirants1088283spirants
spireas94412513spireas
spirems11499563spirems
spires84628113spi_res
spirit83519923spirit_
spiroid10219823spiroid
spirt75032953spi_rt_
spit65545083spi__t_
spitals93011593spitals
spite75430663spi__te
spites84127333spi_tes
spitz166017973spi__tz
spitzes1849183spitzes
spivs105114243spi__vs
splats84817303sp_lats
splents93912133splents
splints94511743splints
splits85416413sp_lits
spoofs114011813sp_oofs
spooks124312933sp_ooks
spools85115913sp_ools
spoons84116023sp_oons
spoors84014033sp_oors
sports84619183sp_orts
spot65540693sp__ot_
spouts85115113sp_outs
sprats85819933sp_rats
spright132010403spright_
sprigs94814773sprig__s
sprints94113773sprints
sprits85122533sp_rits
sprouts949983sprouts
spumous1135853spumous
spurts84814973sp_urts
stigmas10206643stigmas
stilts67915313sti_lts
stingos8459453stingo_s
stints65119763sti_nts
stots54828553s__tots
sublots92410913sublots
suints64617783sui_nts
suitors73012493suitors
suits55028053sui__ts
swifts12408173swi_fts
swigs96213663swig__s
swivets13436963swivets
swots85518433s__wots
tights104015853_tights
tigons74112263_tigons
tricots9311563tricots
trigons84312093trigons
trigos74214173trigo_s
uplights14165053uplights
uprights14145313uprights
uproots937143uproots
upshots1235193upshots
vigors102911483_vigors
weights14409553weights
wights133315783_wights
wrights14318993wrights

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.403443402.0
2DLD Change Limit1340272506.11021935.7
3Display Results2502500.0803125.0
 (SQL Overall)1786912506.59327103.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.