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

219 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
spile7523008(None) 
pile65649691_pile
smile74823911smile
spale74929211spale
spice95528811spice
spiel74623911spiel
spike114922841spike
spiled94621991spiled
spiles84227911spiles
spill74821161spill
spilt75532221spilt
spine76534421spine
spire75828691spire
spite75430661spite
stile54931571stile
agile65122262agile
anile54634462anile
apple94517672apple
aspire8612122aspire
axile126020512axile
bile66147172_bile
chile105626892chile
edile64819492edile
exile126117652exile
file75446642_file
guile64521132guile
maile75232212maile
mile66352562_mile
opine77422462opine
pale66055012_pale
pele65539552_pele
pice84641092_pice
pie55457402_pi_e
pike106335212_pike
pilea75123952_pilea
piled85232992_piled
pilei74021782_pilei
piles74742612_piles
pili66130352_pili
pill65339462_pill
pily96132732_pily
pine67755712_pine
pipe86434432_pipe
plie65127392_plie
pole65951302_pole
pule65040952_pule
rile45650532_rile
sable74732162sable
saice75424052saice
sail45447162sail_
sailed74327762sailed
sailer63526102sailer
sails55738102sails
sale44959702s_ale
scale74629142scale
sedile73517232sedile
seine55732872seine
seise54727852seise
seize143819502seize
selle54428312selle
senile63420212senile
shale85332832shale
shiel811023772shiel
shill85325332shill
shily115222012shily
shine85533092shine
shire84727132shire
shive114423422shive
sice65545592s_ice
side55444482s_ide
sidle65124032sidle
sike87138782s_ike
sild55030582s_ild
silex123417412s_ilex
silk85529322s_ilk
sill45545152s_ill
silo46037912s_ilo
silt46558192s_ilt
simile83115622simile
sine46560622s_ine
sipe67341042s_ipe
sire46150412s_ire
site47052412s_ite
size135630962s_ize
skill94316722skill
skite95120042skite
skive124614112skive
slice74925822slice
slide64725412slide
slily85820032slily
slime74925752slime
slipe75626132slipe
smiled93716432smiled
smiler83916682smiler
smiles84522292smiles
smiley114012302smiley
smite75224862smite
snide64318722snide
snipe75320572snipe
socle7419572socle
soil46138822soil_
soiled73822472soiled
soils55327982soils
sole46053672s_ole
sopite84917712sopite
space95325672space
spade84423322spade
spae65034322sp_ae
spail74921552spail_
spails84817822spails
spake114322742spake
spales84728102spales
spall74919302spall
spare75135562spare
spate74731582spate
speel74420762speel
speil75618642speil_
speiled104412122speiled
speils84116222speils
speise84614252speise
spell75020302spell
spelt75430192spelt
spic85227432spi_c
spica94717942spica
spicae104313702spicae
spiced115218312spiced
spicer104719312spicer
spices104326032spices
spicey134414232spicey
spick134519072spick
spics94123242spics
spicule11269932spicule
spicy125417712spicy
spider94516802spider
spied85427712spied
spieled104811882spieled
spieler93111232spieler
spiels85317952spiels
spier75728032spier
spies76037622spies
spiff133616392spiff
spik105419712spi_k
spiked134915552spiked
spiker124315662spiker
spikes124520712spikes
spikey155411332spikey
spiks114117472spiks
spiky146014112spiky
spilled103613622spilled
spiller92914322spiller
spills84717452spills
spilth11469732spilth
spin66231302spi_n
spindle103210092spindle
spined95423942spined
spinel85317332spinel
spines85132032spines
spinet85629752spinet
spins75327982spins
spinule9299992spinule
spiny104921302spiny
spirea84015632spirea
spired94921862spired
spirem104214162spirem
spires84628112spires
spirt75032952spirt
spiry105017352spiry
spit65545082spi_t
spited94820442spited
spites84127332spites
spits74429552spits
spittle937922spittle
spitz166017962spitz
spiv95917792spi_v
spivs105114242spivs
splice104915102splice
spline86020532spline
split75729012split
spode84617702spode
spoil75818642spoil_
spoiled104811352spoiled
spoiler93310682spoiler
spoils84614532spoils
spoilt85016592spoilt
spoke114818662spoke
spore75428592spore
spree74830862spree
sprite84421772sprite
sprue74717632sprue
spue66025522sp_ue
spume95817312spume
stale55637102stale
stele55026842stele
stifle93611902stifle
stiles64328762stiles
still54922072still
stilt54831982stilt
stime76521792stime
stipe76523372stipe
stole54928812stole
style85519362style
suite54829562suite
supine84216692supine
supple10410202supple
swale85221592swale
swill83417372swill
swine85625302swine
swipe105217082swipe
swiple11379232swiple
swive115316192swive
tile45451442_tile
toile54626492toile
unpile81914322unpile
uppile10178502uppile
utile54718932utile
vile76139802_vile
voile84719722voile
while115418692while
wile75944372_wile

Search took 2 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.0931921408.6
2DLD Change Limit538002191.70331591.3
3Display Results2192190.0633476.2
 (SQL Overall)1786912191.85996122.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.