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

179 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
spiks11411747(None) 
spicks144814991spicks
spics94123241spics
spies76037621spies
spik105419711spik_
spike114922841spike
spikes124520711spikes
spiky146014111spiky
spins75327981spins
spits74429551spits
spivs105114241spivs
aspics104211562aspics
aspis74618142aspi_s
epics95014282epics
espies83716802espies
haiks125120932haiks
kliks8398822kliks
paiks114719852paiks
pias66542552_pias
picks135226142_picks
pics85633912_pics
pies66949602_pies
pigs76634222_pigs
pika106322952_pika
pikas114218092_pikas
pike106335212_pike
pikes115031032_pikes
piki106520562_piki
pikis115116392_pikis
pinks115729382_pinks
pins65558452_pins
pips85837132_pips
pis56362032_pi_s
piss65033332_piss
pits66348742_pits
psis68120342psi_s
sacks114228872sacks
saids65328852saids
sails55738102sails
sains55639972sains
sakis95323672sakis
sarks96632462sarks
seeks94724642seeks
seifs85019332seifs
seis45542392sei_s
sepias83616102sepias
sheiks132510012sheiks
shies86136552shies
shiksa1394652shiksa
shikse1386072shikse
shims104422552shims
shins85131042shins
ships105123772ships
shirks134814122shirks
shits84731172shits
shivs115018802shivs
shtiks13297832shtiks
sibs65933542s_ibs
sicks115127622sicks
sics65234092s_ics
sika86021322s_ika
sikas94617022s_ikas
sike87138782s_ike
sikes96236082s_ikes
silks94620682silks
sims65737172s_ims
sinks95529182sinks
sins46755272s_ins
sipes76036952sipes
sips65740102s_ips
sirs44338332s_irs
sis37360542s_i_s
sits45050202s_its
skids104615322skids
skies95026832skies
skims114517192skims
skinks94511652skinks
skins94723462skins
skips115616602skips
skis84825292ski_s
skits94721862skits
slicks124816112slicks
slims75423652slims
slinks104315152slinks
slips76023722slips
slits56128852slits
smirks124910122smirks
snibs75613762snibs
snicks124312472snicks
snips75818012snips
snits54124832snits
soaks95220292soaks
socks114926082socks
soils55327982soils
sooks94425452sooks
souks94820522souks
spaes76029972spaes
spails84817822spails
spaits85017472spaits
spake114322742spake
spams94922192spams
spanks124514122spanks
spans74528732spans
sparks124616362sparks
spars75431542spars
spas67036722sp_as
spats75031382spats
spays105520512spays
speaks125114582speaks
specks144312702specks
specs96916672specs
speils84116222speils
speirs85013232speirs
speiss84311642speiss
spews105015922spews
spic85227432spi_c
spica94717942spica
spicas104715822spicas
spice95528812spice
spices104326032spices
spick134519072spick
spicy125417712spicy
spied85427712spied
spiel74623912spiel
spiels85317952spiels
spier75728032spier
spiers84421742spiers
spiff133616402spiff
spiffs14328472spiffs
spiked134915552spiked
spiker124315662spiker
spikers135311992spikers
spikey155411332spikey
spile75230082spile
spiles84227912spiles
spill74821162spill
spills84717462spills
spilt75532222spilt
spin66231302spi_n
spine76534422spine
spines85132032spines
spiny104921302spiny
spire75828692spire
spires84628112spires
spirt75032952spirt
spirts85317132spirts
spiry105017352spiry
spit65545082spi_t
spite75430662spite
spites84127332spites
spitz166017972spitz
spiv95917792spi_v
splits85416412splits
spoils84614532spoils
spoke114818662spoke
spokes124417212spokes
spooks124312932spooks
spots74424112spots
sprigs94814772sprigs
sprits85122532sprits
spuds85113672spuds
spues75025382spues
spunks12349332spunks
spurs74621522spurs
sris45434152sri_s
sticks125118612sticks
sties55132982sties
stinks105616832stinks
stirks104914242stirks
stirs55921622stirs
sucks114523072sucks
suits55028052suits
suks85927122s_uks
sulks94818462sulks
swigs96213662swigs
swims105514142swims
swinks134610652swinks
swiss86712902swiss
tupiks1235492tupiks

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.310576422.6
2DLD Change Limit538001791.47036598.6
3Display Results1791790.0463891.3
 (SQL Overall)1786911791.82697859.3
 
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.