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

308 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
spies7603762(None) 
espies83716801espies
pies66949601_pies
shies86136551shies
sipes76036951sipes
skies95026831skies
spaes76029971spaes
spices104326031spices
spics94123241spics
spied85427711spied
spiel74623911spiel
spiels85317951spiels
spier75728031spier
spiers84421741spiers
spikes124520711spikes
spiks114117471spiks
spiles84227911spiles
spines85132031spines
spins75327981spins
spires84628111spires
spites84127331spites
spits74429551spits
spivs105114241spivs
spues75025381spues
sties55132981sties
amies76837692amies
apes66047432ap_es
apices104916262apices
apres75426402apres
apses76823912apses
aspics104211562aspics
aspires9612042aspires
aspis74618142aspi_s
aspises9611642aspises
bries74942152bries
copies104130302copies
cries75438402cries
dies55653522_dies
dries64733672dries
epees75219832epees
epics95014282epics
espied9359772espied
flies85630712flies
fries85535602fries
gies55641422_gies
hies74842832_hies
ivies84215762ivies
lies46454192_lies
opes65942612op_es
opines84820702opines
pees65257372_pees
pes57259782_p_es
pias66542552_pias
pics85633912_pics
pie55457402_pie_
pied75035362_pied
pier66035292_pier
piers75926332_piers
pigs76634222_pigs
pikes115031032_pikes
piles74742612_piles
pines76048862_pines
pins65558452_pins
pipes96030142_pipes
pips85837132_pips
pis56362032_pi_s
piss65033332_piss
pits66348742_pits
pixes144323172_pixes
plies74526512plies
pries74339532pries
psis68120342psi_s
pyes95528992_pyes
ripes75435772ripes
sabes76437462sabes
sades65239892sades
safes85226722safes
sages65339062sages
saices84221802saices
saids65328852saids
sails55738102sails
sains55639972sains
sakes95540752sakes
sales56055592sales
sanes55649072sanes
sanies63031952sanies
sapiens9310172sapiens
sates54949322sates
saves85838632saves
saxes125229342saxes
scries85226822scries
sees45361052s_ees
seifs85019332seifs
seines65029902seines
seis45542392sei_s
seise54727852seise
seises64026712seises
seizes154317532seizes
semes75731582semes
sepias83616102sepias
sepses84515882sepses
seres55448892seres
series64540972series
sexes126126222sexes
shes75734352s_hes
shied96125492shied
shiel811023772shiel
shiels95418922shiels
shier85428942shier
shiers94921752shiers
shiest95821532shiest
shims104422552shims
shines95028912shines
shins85131042shins
ships105123772ships
shires95225572shires
shits84731172shits
shives124921412shives
shivs115018802shivs
shoes85429662shoes
sibs65933542s_ibs
sices75637272sices
sics65234092s_ics
sides65838362sides
sikes96236082sikes
sims65737172s_ims
sines55954822sines
sins46755272s_ins
sipe67341042sipe_
siped84927682siped
sips65740102s_ips
sires55945372sires
sirs44338332s_irs
sis37360542s_i_s
sises55233832sises
sites56045432sites
sits45050202s_its
sixes124526362sixes
sizes146727762sizes
skees95023122skees
skids104615332skids
skied104417752skied
skier95119592skier
skiers104713702skiers
skiey125012892skiey
skims114517192skims
skins94723462skins
skips115616602skips
skis84825292ski_s
skites104418042skites
skits94721862skits
skives134113942skives
slices84022852slices
slides73922182slides
slier54827242slier
sliest66621962sliest
slimes84722042slimes
slims75423652slims
slipes84921412slipes
slips76023722slips
slits56128852slits
sloes54728872sloes
slues54527172slues
smiles84522292smiles
smites83921922smites
snibs75613762snibs
snipes83917392snipes
snips75818012snips
snits54124832snits
snyes85012752snyes
soils55327982soils
sokes95031422sokes
soles55547922soles
sones55444142sones
sophies12314622sophies
sopites93817172sopites
sores55454282sores
spaces104722632spaces
spades94222582spades
spae65034322spae_
spaed85522272spaed
spails84817822spails
spaits85017472spaits
spales84728102spales
spams94922192spams
spans74528732spans
spares84834552spares
spars75431542spars
spas67036722sp_as
spates85028172spates
spats75031382spats
spavies123012952spavies
spays105520512spays
spec85821972sp_ec
species11314132species
specs96916672specs
sped76031492sp_ed
speed85526622speed
speeds94316052speeds
speel74420762speel
speels85116392speels
speer74623902speer
speers85019952speers
speil75618642speil
speils84116222speils
speir75315362speir
speirs85013232speirs
speise84614252speise
speises93813932speises
speiss84311642speiss
spew95421872sp_ew
spews105015922spews
spic85227432spi_c
spica94717942spica
spicas104715822spicas
spice95528812spice
spiced115218312spiced
spicer104719312spicer
spicers113815552spicers
spicey134414232spicey
spick134519072spick
spicks144814992spicks
spicy125417712spicy
spider94516802spider
spiders103914412spiders
spiff133616402spiff
spiffs14328472spiffs
spik105419712spi_k
spike114922842spike
spiked134915552spiked
spiker124315662spiker
spikers135311992spikers
spikey155411332spikey
spiky146014112spiky
spile75230082spile
spiled94621992spiled
spill74821162spill
spills84717462spills
spilt75532222spilt
spin66231302spi_n
spine76534422spine
spined95423942spined
spinel85317332spinel
spinels94512442spinels
spinet85629752spinet
spinets94714812spinets
spiny104921302spiny
spire75828692spire
spirea84015632spirea
spireas94412512spireas
spired94921862spired
spirem104214162spirem
spirems11499562spirems
spirt75032952spirt
spirts85317132spirts
spiry105017352spiry
spit65545082spi_t
spite75430662spite
spited94820442spited
spitz166017972spitz
spitzes1849182spitzes
spiv95917792spi_v
splices113914382splices
splines94718892splines
splits85416412splits
spodes94817432spodes
spoils84614532spoils
spokes124417212spokes
spores84726612spores
spots74424112spots
spree74830862spree
sprees85620642sprees
sprier84119062sprier
spriest92718652spriest
sprigs94814772sprigs
sprites94220332sprites
sprits85122532sprits
sprues84515762sprues
spuds85113672spuds
spue66025522spue_
spued84918472spued
spumes1021314882spumes
spurs74621522spurs
sris45434152sri_s
stied65723032stied
stiles64328772stiles
stimes85920572stimes
stipes84524052stipes
stirs55921622stirs
styes86316522styes
sues46247652s_ues
suites63727402suites
suits55028052suits
supes75628302supes
supines94216382supines
swigs96213662swigs
swims105514142swims
swipes114114332swipes
swiss86712902swiss
swives123915182swives
syces106416462syces
sykes124816862sykes
ties45248312_ties
tries55742812tries
vies75238622_vies
wipes104827082wipes
wries85827742wries
yipes106017842yipes

Search took 4 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 Filter178691538000.546327272.9
2DLD Change Limit538003082.90618513.4
3Display Results3083080.0933311.8
 (SQL Overall)1786913083.54550406.5
 
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.