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

217 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
spiles8422791(None) 
piles74742611_piles
smiles84522291smiles
spales84728101spales
spices104326031spices
spiels85317951spiels
spies76037621spi_es
spikes124520711spikes
spile75230081spile_
spiled94621991spiled
spills84717461spills
spines85132031spines
spires84628111spires
spites84127331spites
stiles64328771stiles
apices104916262apices
apples104315762apples
aspires9612042aspires
aspises9611642aspises
biles75542142_biles
chiles115425302chiles
ediles74016982ediles
espies83716802espi_es
exiles134816402exiles
files85441272_files
guiles73919282guiles
mailes84329112mailes
miles74645072_miles
opines84820702opines
pales75753802_pales
peles75738082_peles
pies66949602_pi_es
pikes115031032_pikes
pile65649692_pile_
pilea75123952_pilea
piled85232992_piled
pilei74021782_pilei
pileus84514942_pileus
pilis75825202_pilis
pills74130972_pills
pilus75921062_pilus
pines76048862_pines
pipes96030142_pipes
pixes144323172_pixes
plies74526512_plies
poles75351002_poles
pules74538812_pules
riles55343642_riles
sables85026692sables
saices84221802saices
sailed74327762sailed
sailer63526102sailer
sailers73822322sailers
sails55738102sail_s
sales56055592s_ales
scales84529312scales
seines65029902seines
seises64026712seises
seizes154317532seizes
selles64426982selles
seniles72618022seniles
shales94731252shales
shiels95418922shiels
shies86136552shi_es
shills94519612shills
shines95028912shines
shires95225572shires
shives124921412shives
sices75637272s_ices
sides65838362s_ides
sidles74721152sidles
sikes96236082s_ikes
silds65520522s_ilds
silex123417412s_ilex
silks94620682s_ilks
sills55135992s_ills
silos56029432s_ilos
silts55330822s_ilts
similes92915232similes
sines55954822s_ines
sipes76036952s_ipes
sires55945372s_ires
sises55233832s_ises
sites56045432s_ites
sixes124526362s_ixes
sizes146727762s_izes
skies95026832ski_es
skills104313922skills
skites104418042skites
skives134113942skives
slices84022852slices
slides73922182slides
slimes84722042slimes
slipes84921412slipes
smile74823922smile_
smiled93716432smiled
smiler83916682smiler
smilers94113852smilers
smiley114012302smiley
smileys12336322smileys
smites83921922smites
snipes83917392snipes
socles8418452socles
soiled73822472soiled
soils55327982soil_s
soles55547922s_oles
sopites93817172sopites
spaces104722632spaces
spades94222582spades
spaes76029972sp_aes
spails84817822spail_s
spale74929212spale_
spalls84217342spalls
spares84834552spares
spates85028172spates
speels85116392speels
speiled104412122speiled
speils84116222speil_s
speises93813932speises
spells84617682spells
spelts84614642spelts
spicas104715822spicas
spice95528812spice_
spiced115218312spiced
spicer104719312spicer
spicers113815552spicers
spicey134414232spicey
spicks144814992spicks
spics94123242spi_cs
spicules12219802spicules
spider94516802spider
spiders103914412spiders
spied85427712spi_ed
spiel74623912spi_el
spieled104811882spieled
spieler93111232spieler
spielers10319652spielers
spier75728032spi_er
spiers84421742spiers
spiffs14328472spiffs
spike114922842spike_
spiked134915552spiked
spiker124315662spiker
spikers135311992spikers
spikey155411332spikey
spiks114117472spi_ks
spill74821162spil_l
spilled103613622spilled
spiller92914332spiller
spillers103311702spillers
spilt75532222spil_t
spilth11469732spilth
spilths12356022spilths
spindles112710352spindles
spine76534422spine_
spined95423942spined
spinel85317332spinel
spinels94512442spinels
spinet85629752spinet
spinets94714812spinets
spinless10238702spinless
spins75327982spi_ns
spinules10249332spinules
spire75828692spire_
spirea84015632spirea
spireas94412512spireas
spired94921862spired
spirem104214162spirem
spirems11499562spirems
spirts85317132spirts
spite75430662spite_
spited94820442spited
spits74429552spi_ts
spittles1038332spittles
spitzes1849182spitzes
spivs105114242spi_vs
splices113914382splices
splines94718892splines
splits85416412splits
spodes94817432spodes
spoiled104811352spoiled
spoiler93310682spoiler
spoilers10238632spoilers
spoils84614532spoil_s
spokes124417212spokes
spores84726612spores
sprees85620642sprees
sprites94220332sprites
sprues84515762sprues
spues75025382sp_ues
spumes1021314882spumes
stales65538292stales
steles63725662steles
sties55132982sti_es
stifles103013392stifles
stile54931572stile_
stills64118572stills
stilts67915312stilts
stimes85920572stimes
stipes84524052stipes
stoles63927672stoles
styles94418652styles
suites63727402suites
supines94216382supines
supples11511282supples
swales93920762swales
swills94213362swills
swipes114114332swipes
swiples12339642swiples
swives123915182swives
tiles55542102_tiles
toiles63923512toiles
unpiles92112782unpiles
uppiles11208262uppiles
voiles94616442voiles
whiles124418012whiles
wiles85437872_wiles

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.326548131.9
2DLD Change Limit825512172.28336159.0
3Display Results2172170.0603616.7
 (SQL Overall)1786912172.66966950.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.