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

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

422 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
splicer11471052(None) 
slicer84117601s_licer
spicer104719311sp_icer
splice104915101splice_
spliced124310591spliced
splicers12338111splicers
splices113914381splices
placer105117742_placer
plier75221282_pli_er
policer113112682policer
pricer103918292_pricer
slice74925822s_lice_
sliced94416312s_liced
slicers94114922s_licers
slices84022852s_lices
slicker133314532s_licker
slider73918362s_lider
slier54827242s_li_er
sliver94116592s_liver
solacer93011102solacer
solider82912452solider
spacer104917792sp_acer
spacier114011632spacier
spencer113610972spencer
spice95528812sp_ice_
spiced115218312sp_iced
spicers113815552sp_icers
spicery14499012sp_icery
spices104326032sp_ices
spicey134414232sp_icey
spicier115112462sp_icier
spider94516802sp_ider
spier75728032sp_i_er
spiker124315662sp_iker
spiller92914332spiller
spline86020532spline_
splined105013112splined
splines94718892splines
splinter10329702splinter
splitter10348442splitter
spoiler93310682spoiler
sprier84119062spri_er
sprucer11317682sprucer
aliner65621983_aliner
apices104916263ap_ices
aplite8316393aplite_
aplites9314933aplites
applier1137903appli_er
aspirer967903asp_irer
belier84423563beli_er
byliner1235723byliner
caliber1139733caliber
calices114321693calices
caliper11410963caliper
chicer134513603_chicer
choicer14197893choicer
cilice103213353cilice_
cilices113814023cilices
clicker154111883_clicker
culices113713123culices
cylices14359283cylices
deicer94114413_deicer
deliver113312243deliver
dicer85426423__dicer
displacer1446433displacer
eelier64216463eeli_er
enticer91510423enticer
epimer10109153ep_imer
espalier1036363espali_er
flicker163610623_flicker
flier86023403_fli_er
glider84614263_glider
helices12313723helices
holier94921623holi_er
inlier63615363inli_er
juicer1536283_juicer
lacer75833753__lacer
liber74723623__liber
lice66045073__lice_
licker125222043__licker
lier45942473__li_er
lifer85822153__lifer
liger65024473__liger
liker95627063__liker
liner55938923__liner
liter54736343__liter
liver85132963__liver
malice104818483malice_
malices114316623malices
nicer74618293__nicer
noticer937273noticer
obliger1035283obliger
officer1534213officer
oilier64417233oili_er
pacer96131613_p_acer
pacier105018683_pacier
palier85023573pali_er
pice84641103_p_ice_
picker144422173_p_icker
piecer105213083_piecer
pier66035303_p_i_er
piker115622843_p_iker
pilfer1139163_pilfer
pincer104019173_pincer
piper96523193_p_iper
place94824613_place_
placed114318003_placed
placers114515263_placers
places104323703_places
placet103923673_placet
plaice10311553_plaice_
plaices11411143_plaices
plainer93811983_plainer
plaiter93615393_plaiter
planer84122663_planer
plater84427693_plater
player115215213_player
plica9613373_plic_a
plicae10410953_plicae
plical10411683_plical
plie65127393_pli_e_
plied85118593_pli_ed
pliers84715153_pli_ers
plies74526513_pli_es
plinker134010973_plinker
plover115312613_plover
plower114315063_plower
plucker15368253_plucker
plyer106214333_pl_yer
poiser84217243_poiser
police102918563police_
policed123212233policed
policers12259993policers
polices113118053polices
politer92417073politer
price93725413_price_
priced115018883_priced
pricers113915063_pricers
prices104524543_prices
pricey134412633_pricey
pricier113313113_pricier
pricker154013413_pricker
prier75027763_pri_er
primer105118683_primer
prizer174714883_prizer
pumicer1335063pumicer
relier65826183reli_er
replacer12279743replacer
replier94214973repli_er
resplice1237253resplice_
respliced1445543respliced
resplices1336623resplices
ricer74726613__ricer
rulier65016353ruli_er
sagier73717163sagi_er
saice75424053s_aice_
saices84221803s_aices
sailer63526103s_ailer
salic73424713salic__
salicin9311223salicin
saline65132703saline_
salines74029413salines
sallier73320433sallier
salter64325083sal_ter
saltier74318633saltier
saluter73512453saluter
salver94617753sal_ver
sappier113613123sappi_er
saucer84314103s_aucer
saucier9810283saucier
scalier94316913scali_er
scarcer113911373scarcer
scilicet1249543scilicet
scolices1238733scolices
scriber113910973scriber
seducer1056503seducer
seiner64622483s_einer
seiser65318343s_eiser
seizer154114573s_eizer
seller63824603sel_ler
seltzer1635213seltzer
semplice1447013semplice_
servicer1335263servicer
sexier13310683sexi_er
shalier103116423shali_er
shicker163914823s_hicker
shier85428943s_hi_er
shiner93820873s_hiner
shiver124517373s_hiver
shriver134712193shriver
sice65545603s__ice_
sices75637273s__ices
sicker124023903s__icker
siker95326033s__iker
silencer1036303silencer
silica8311243silic_a
silicas9310603silicas
silicic1147603silicic
silicle937753silicle
silicles1037073silicles
silicon9117533silicon
silkier114411643silkier
siller64026063sil_ler
sillier74017593sillier
siltier73413863siltier
silver93815813sil_ver
simplices1546043simplices
siver85728613s__iver
sizer145521813s__izer
sizier1514813393sizi_er
skier95119603s_ki_er
skiver134612103s_kiver
slacker133915293s_lacker
slaker104219273s_laker
slater64429183s_later
slaver94419613s_laver
slayer93916333s_layer
slick115520523s_lic_k
slicked144413843s_licked
slicken13309293s_licken
slickers143112553s_lickers
slicks124816113s_licks
slide64725423s_lide_
sliders83515223s_liders
slides73922183s_lides
slime74925753s_lime_
slimed94915123s_limed
slimes84722043s_limes
slimier93212013s_limier
slimmer114211343s_limmer
slinger83413833s_linger
slipe75626133s_lipe_
sliped95417063s_liped
slipes84921413s_lipes
slipper113712983s_lipper
slither104112983s_lither
slitter73615873s_litter
slivers104115253s_livers
sloper84615913s_loper
slower94016153s_lower
sluice849513sluice_
sluiced1046053sluiced
sluices959073sluices
slyer85515123s_l_yer
smiler83916683s_miler
smiter83616413s_miter
snicker133012673s_nicker
snider74413913s_nider
sniper84413643s_niper
soccer1038543s_occer
solace83415823solace_
solaced102911063solaced
solacers10268893solacers
solaces93116133solaces
solder73921343sol_der
soldier82812153soldier
solicit9315743solicit
solver94016703sol_ver
soppier112711583soppi_er
space95325673sp_ace_
spaced114517253sp_aced
spacers113813873sp_acers
spaces104722633sp_aces
spacey136212533sp_acey
spader94317133sp_ader
spadices1336093spadices
spaller92713473spaller
spammer133410433spammer
spancel1147363spancel
spanker133612353spanker
spanner94312563spanner
sparer84524963sp_arer
sparger103613083sparger
sparker133914363sparker
sparser94311483sparser
spatter94016523spatter
spawner12347363spawner
speaker133311213speaker
spearer93913663spearer
specced14266703specced
specie10412223specie_
species11314133species
specter113111733specter
speeder103811073speeder
speer74623903sp__eer
speiled104412123speiled
speir75315363spei__r
speired103811103speired
speise84614253speise_
speises93813933speises
speller95415153speller
spelter94113703spelter
spence103813793spence_
spencers12269193spencers
spences113413923spences
spender103713693spender
spewer115112153sp_ewer
sphincter1642233sphincter
spic85227433sp_ic__
spica94717943sp_ic_a
spicae104313703sp_icae
spicas104715823sp_icas
spick134519073sp_ic_k
spicks144814993sp_icks
spics94123243sp_ic_s
spicy125417713sp_ic_y
spiders103914413sp_iders
spidery13308203sp_idery
spied85427713sp_i_ed
spiel74623913sp_i_el
spieler93111233spieler
spiers84421743sp_i_ers
spies76037623sp_i_es
spike114922843sp_ike_
spiked134915553sp_iked
spikers135311993sp_ikers
spikes124520713sp_ikes
spikey155411333sp_ikey
spikier13369983spikier
spile75230083sp_ile_
spiled94621993sp_iled
spiles84227913sp_iles
spilled103613623spilled
spillers103311703spillers
spine76534423sp_ine_
spined95423943sp_ined
spinel85317333sp_inel
spines85132033sp_ines
spinet85629753sp_inet
spinier93715163spinier
spinner93912263spinner
spinor839943sp_inor
spire75828693sp_ire_
spirea84015633sp_irea
spired94921863sp_ired
spirem104214163sp_irem
spires84628113sp_ires
spirier93214073spirier
spite75430663sp_ite_
spited94820443sp_ited
spites84127333sp_ites
spitter94015183spitter
splake1259783splake_
splakes1349673splakes
splasher1335663splasher
splatter10348883splatter
splayed13357813splayed
spleen8310263spl_een
splicing1338963splicing
spliff1438603spli_ff
spliffs1533563spliffs
splint85223283spli_nt
splinted11369253splinted
splinters11277923splinters
splintery14264793splintery
splints94511743splints
split75729013spli__t
splits85416413spli_ts
splitters11307323splitters
splore81611303splore_
splores91910953splores
splurger1143813splurger
splutter10357443splutter
spoiled104811353spoiled
spoilers10238633spoilers
sponger1038523sponger
spoofer12368723spoofer
spooler93711383spooler
sporter93616553sporter
spotter94514883spotter
spouter94213223spouter
sprayer12369043sprayer
sprigger12366503sprigger
springer113311753springer
sprinter103810813sprinter
sprite84421773sprite_
sprites94220333sprites
spritzer1944563spritzer
spruce103910873spruce_
spruced12307533spruced
spruces113810503spruces
sprucier1254793sprucier
spryer11418533sp_ryer
spudder11256553spudder
spumier1137903spumier
spurner9269653spurner
spurrer93710223spurrer
spurter94013003spurter
sputter94014053sputter
staider83912613staider
stainer73614923stainer
sticker133515883s_ticker
stiller73414303stiller
stiver93915733s_tiver
stolider936603stolider
stricter1039423stricter
strider84315723strider
striker113714173striker
striper94514793striper
striver104315203striver
stuiver10447083stuiver
styliser11185523styliser
stylizer20185443stylizer
sublimer1237613sublimer
sufficer16225823sufficer
suiter64121813s_uiter
sulker104015923sul_ker
sulkier113811963sulkier
supplier1246603suppli_er
surlier72915443surli_er
surplice1246203surplice_
surpliced1444153surpliced
surplices1346043surplices
swiller103211663swiller
uglier748953ugli_er
ulcer7310753_ul_cer
uplifter1363903uplifter
upriser9218763upriser
upriver12196933upriver
veliger1137313veliger
voicer113910543_voicer
wilier93217073wili_er

Search took 8 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 Filter1786911340270.406440125.6
2DLD Change Limit1340274226.87319500.5
3Display Results4224220.1562705.1
 (SQL Overall)1786914227.43524033.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.