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 “spices” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

180 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
spices10432603(None) 
apices104916261apices
saices84221801saices
sices75637271s_ices
slices84022851slices
spaces104722631spaces
spicas104715821spicas
spice95528811spice_
spiced115218311spiced
spicer104719311spicer
spicers113815551spicers
spicey134414231spicey
spicks144814991spicks
spics94123241spic_s
spies76037621spi_es
spikes124520711spikes
spiles84227911spiles
spines85132031spines
spires84628111spires
spites84127331spites
splices113914381splices
amices105018012amices
aspics104211562aspic_s
aspires9612042aspires
aspises9611642aspises
auspices1236442auspices
bices95029962_bices
deices94119372deices
dices86434242_dices
epics95014282epic_s
espies83716802espi_es
fices106031162_fices
hospices1587632hospices
ibices10398162ibices
ices66129642__ices
juices1549422juices
opines84820702opines
paces96741112_paces
picas94626522_picas
pice84641092_pice_
picks135226142_picks
pics85633912_pic_s
pieces104217272_pieces
pies66949602_pi_es
pikes115031032_pikes
piles74742612_piles
pines76048862_pines
pipes96030142_pipes
pixes144323172_pixes
prices104524542prices
puces94924632_puces
rices75536152_rices
saice75424052saice_
sauces84919502sauces
seiches12513812seiches
seines65029902seines
seises64026712seises
seizes154317532seizes
shies86136552shi_es
shines95028912shines
shires95225572shires
shives124921412shives
sice65545592s_ice_
sicks115127622s_icks
sics65234092s_ic_s
sides65838362s_ides
sikes96236082s_ikes
sines55954822s_ines
sipes76036952s_ipes
sires55945372s_ires
sises55233832s_ises
sites56045432s_ites
sixes124526362s_ixes
sizes146727762s_izes
skies95026832ski_es
skites104418042skites
skives134113942skives
slice74925822slice_
sliced94416312sliced
slicer84117602slicer
slicers94114922slicers
slicks124816112slicks
slides73922182slides
slimes84722042slimes
slipes84921412slipes
sluices959072sluices
smiles84522292smiles
smites83921922smites
snicks124312472snicks
snipes83917392snipes
sopites93817172sopites
space95325672space_
spaced114517252spaced
spacer104917792spacer
spacers113813872spacers
spacey136212532spacey
spades94222582spades
spadices1336092spadices
spaes76029972sp_aes
spales84728102spales
spares84834552spares
spates85028172spates
species11314132species
specks144312702specks
specs96916672spec_s
speises93813932speises
spences113413922spences
spic85227432spic__
spica94717942spic_a
spicae104313702spicae
spicery14499012spicery
spicier115112462spicier
spiciest122711602spiciest
spick134519072spic_k
spicules12219802spicules
spicy125417712spic_y
spider94516802spider
spiders103914412spiders
spied85427712spi_ed
spiel74623912spi_el
spiels85317952spiels
spier75728032spi_er
spiers84421742spiers
spiffs14328472spiffs
spike114922842spike_
spiked134915552spiked
spiker124315662spiker
spikers135311992spikers
spikey155411332spikey
spiks114117472spi_ks
spile75230082spile_
spiled94621992spiled
spills84717462spills
spine76534422spine_
spined95423942spined
spinel85317332spinel
spinels94512442spinels
spinet85629752spinet
spinets94714812spinets
spins75327982spi_ns
spire75828692spire_
spirea84015632spirea
spireas94412512spireas
spired94921862spired
spirem104214162spirem
spirems11499562spirems
spirts85317132spirts
spite75430662spite_
spited94820442spited
spits74429552spi_ts
spitzes1849182spitzes
spivs105114242spi_vs
splice104915102splice_
spliced124310592spliced
splicer114710522splicer
splicers12338112splicers
splines94718892splines
spodes94817432spodes
spokes124417212spokes
spores84726612spores
sprees85620642sprees
sprites94220332sprites
spruces113810502spruces
sprues84515762sprues
spues75025382sp_ues
spumes1021314882spumes
stichs114511652stichs
sticks125118612sticks
sties55132982sti_es
stiles64328772stiles
stimes85920572stimes
stipes84524052stipes
suites63727402suites
supines94216382supines
swipes114114332swipes
swives123915182swives
syces106416462s_yces
trices84826332trices
vices105725532_vices
voices114414012voices

Search took 3 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 Filter178691825510.376475242.0
2DLD Change Limit825511802.50033020.4
3Display Results1801800.0603000.0
 (SQL Overall)1786911802.93660862.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.