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

298 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
splinter1032970(None) 
splinted11369251splinted
splinters11277921splinters
splintery14264791splintery
splitter10348441splitter
sprinter103810811sprinter
linter64625342__linter
painter93814562_painter
planter94017802_planter
plinker134010962_plinker
pointer93814932_pointer
printer93917302_printer
silenter838872silenter
sinter63625922s__inter
slinger83413832s_linger
slitter73615872s_litter
sphincter1642232sphincter
spinier93715162sp_inier
spinner93912262sp_inner
spinster1036682sp_inster
spitter94015182sp_itter
splatter10348882splatter
splicer114710522spli_cer
spline86020532splin_e_
splined105013112splin_ed
splines94718892splin_es
splint85223282splint__
splintered1383922splintered
splints94511742splint_s
splitters11307322splitters
splutter10357442splutter
springer113311752springer
sprinted113411162sprinted
sprinters11329362sprinters
squinter1747362squinter
stinter73614512s_tinter
uplifter1363902uplifter
aglitter935093aglitter
aliner65621983_alin_er
anointer837823anointer
aplite8316393apli_te_
aplites9314933apli_tes
appointer1354423appointer
blinder103912983_blinder
blinker134110213_blinker
blister94415313_blister
blunter94512033_blunter
byliner1235723bylin_er
clinger103812153_clinger
clinker133811663_clinker
cointer93616723_cointer
cylinder1433383cylinder
disinter9310673disinter
enlister847803enlister
fainter103611053_fainter
filister1137403filister
flinder11319873_flinder
flinger113710513_flinger
flinted114411893_flinted
flintier1136393_flintier
flirter10318673_flirter
flitter103413903_flitter
glinted9399373_glinted
glintier945703_glintier
glister84013343_glister
glitter84211803_glitter
hinter94021303__hinter
implanter1385363implanter
imprinter1385243imprinter
inter55028493___inter
jointer14379713_jointer
klister113410643_klister
lifter93814813__lifter
liner55938923__lin_er
linger75226003__linger
linier64423793__linier
linker104321473__linker
linted74021823__linted
lintel64013993__lintel
linters73822633__linters
lintier73613803__lintier
lister64527253__lister
liter54736343__li_ter
litter64324853__litter
malinger11116533malinger
minter84425103__minter
misinter1038833misinter
painted104214633_painted
painters103013023_painters
paintier1048793_paintier
philter12108213_philter
pincer104019173_p_incer
pinder94523453_p_inder
pinger94324093_p_inger
pinier84024693_p_inier
pinker125322443_p_inker
pinner84521503_p_inner
plainer93811983_plain_er
plaister1068013_plaister
plaiter93615393_plaiter
planer84122653_plan_er
plankter1435363_plankter
planner93511623_planner
plantar9369993_plantar
planted103516123_planted
planters102915323_planters
plaster93318693_plaster
plater84427693_pl_ater
platter93917413_platter
pleater93916333_pleater
plier75221283_pli__er
plighter1476623_plighter
plinked143910893_plinked
plinkers14309393_plinkers
plinth11310453_plint_h
plinths1236123_plinths
plotter94113663_plotter
plunder103810503_plunder
plunger104211243_plunger
plunker133910653_plunker
pointe84619313_pointe_
pointed103813983_pointed
pointers103013723_pointers
pointes93216753_pointes
pointier1038303_pointier
politer92417073poli_ter
prinker133412743_prinker
printed104016373_printed
printers103214903_printers
printery13318433_printery
punter84320023_p_unter
quainter1765903quainter
reinter73116843_reinter
reprinter1197353reprinter
sainted84114243s_ainted
salimeter1157373salimeter
saline65132703salin_e_
salines74029413salin_es
salter64325083sal__ter
saluter73512453sal_uter
saunter72913453s_aunter
scanter94215183s_canter
scripter12137773scripter
seiner64622483s_ein_er
shifter132911083s_hifter
shiner93820873s_hin_er
shinier104113143s_hinier
shoplifter1852183shoplifter
shrinker15236363shrinker
shunter103611733s_hunter
sifter94516233s__ifter
silencer1036293silencer
singer74227313s__inger
sinister838583sinister
sinker103620903s__inker
sinner64320603s__inner
sinters74024083s__inters
sister64421583s__ister
sitter63323383s__itter
skinker10319443s_kinker
skinner11348093s_kinner
skirter11338483s_kirter
skitter113810403s_kitter
sklented1335053sklented
slainte738543slainte_
slander84015443s_lander
slanted83514743s_lanted
slater64429183s_l_ater
slender83413593s_lender
slicer84117603s_li_cer
slicker133314533s_licker
slider73918363s_li_der
slier54827243s_li__er
slighter1257823s_lighter
slimier93212013s_limier
slimmer114211343s_limmer
slingers93712683s_lingers
slinked123011383s_linked
slinkier12206933s_linkier
slipper113712983s_lipper
slither104112983s_lither
slitted83513313s_litted
slitters84014133s_litters
slittier837003s_littier
sliver94116593s_li_ver
slotter73314453s_lotter
smiter83616413s_mi_ter
snifter10349623s_nifter
solander948123solander
solider82912453soli_der
spanker133612353sp_anker
spanner94312563sp_anner
spatter94016523sp_atter
spawner12347363spawn_er
specter113111733sp_ecter
spelter94113703sp_elter
spelunker1541963spelunker
spencer113610973sp_encer
spender103713693sp_ender
sphincters1742073sphincters
sphinges14267483sphinges
sphinxes20334403sphinxes
spicer104719313sp_i_cer
spicier115112463sp_icier
spider94516803sp_i_der
spieler93111233sp_ieler
spier75728033sp_i__er
spiker124315663sp_i_ker
spikier13369983sp_ikier
spiller92914333sp_iller
spinate93114813sp_inate_
spindler11297983sp_indler
spine76534423sp_in_e_
spined95423943sp_in_ed
spinel85317333sp_in_el
spines85132033sp_in_es
spinet85629753sp_in_et
spinets94714813sp_inets
spinners103810863sp_inners
spinnery13416593sp_innery
spinney12438923sp_inney
spinor839943sp_in_or
spinsters1136613sp_insters
spinto8410663sp_int_o
spintos939133sp_intos
spirier93214073sp_irier
spirted103913073sp_irted
spite75430663sp_i_te_
spited94820443sp_i_ted
spites84127333sp_i_tes
spitted103912703sp_itted
spitters104113383sp_itters
splasher1335663splasher
splatted11356743splatted
splatters11327543splatters
spleenier1143863spleenier
splendor1143743splendor
splent84720193splent__
splents93912133splent_s
splice104915103spli_ce_
spliced124310593spli_ced
splicers12338113spli_cers
splices113914383spli_ces
splining11310773splining
splintering1444293splintering
splinting1238193splinting
split75729013spli_t__
splits85416413spli_t_s
splurger1143813splurger
splutters11286273splutters
spluttery14293623spluttery
spoiler93310683spoi_ler
spoliate1039243spoliate_
spoliated1246913spoliated
spoliates1138543spoliates
spoliator1144843spoliator
sponger1038523sp_onger
spoonier10167653spoonier
sporter93616553sp_orter
spotter94514883sp_otter
spouter94213223sp_outer
sprier84119063spri__er
sprigger12366503sprigger
springe103913983springe_
springed123911323springed
springers12309983springers
springes114014033springes
springier1236023springier
sprinkler1543573sprinkler
sprint84526793sprint__
sprints94113773sprint_s
sprite84421773spri_te_
sprites94220333spri_tes
spritzer1944563spritzer
spurner9269653spurn_er
spurter94013003sp_urter
sputter94014053sp_utter
squinted1847063squinted
squinters1835523squinters
squintier1844473squintier
squirter1746523squirter
stainer73614923stain_er
stinger84314683s_tinger
stinker113313313s_tinker
stinted82914193s_tinted
stinters83312753s_tinters
stricter1039423stricter
stringer93812943stringer
suiter64121813s_ui_ter
supplanter14113673supplanter
swifter13318053s_wifter
swinger113812563s_winger
tinter63923643__tinter
uplander1145533uplander
uplifted1454423uplifted
uplifters1463283uplifters
uplinked15254203uplinked
winter94222803__winter

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 Filter1786911461620.420425454.8
2DLD Change Limit1461622986.97020970.2
3Display Results2982980.1102709.1
 (SQL Overall)1786912987.50023825.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.