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

239 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
splinting123819(None) 
splining11310771splin_ing
splitting1236561splitting
sprinting12310031sprinting
flinting123412342_flinting
glinting103210052_glinting
linting83820982__linting
painting113614422_painting
planting113515382_planting
plinking153611242_plinking
pointing112813682_pointing
printing113216082_printing
sainting93215732s_ainting
sklenting1475122sklenting
slanting94115092s_lanting
slinging103312862s_linging
slinking133412982s_linking
slitting93012582s_litting
spinning113310812sp_inning
spirting112913632sp_irting
spiting103917622sp_i_ting
spitting113012322sp_itting
splatting1235982splatting
splicing1338962spli_cing
splintering1444292splintering
spoliating1366962spoliating
springing1338742springing
squinting1936222squinting
stinting93415742s_tinting
uplifting1534962uplifting
uplinking1634622uplinking
alining81917043_alin_ing
anointing1038623anointing
appointing1545323appointing
arointing1049363arointing
bepainting15144883bepainting
blinding123210163_blinding
blinking153510623_blinking
blunting11319843_blunting
bylining1446013bylin_ing
clinging122910913_clinging
clinking153611663_clinking
delisting112710503delisting
depainting14156153depainting
dinting93520553__dinting
displanting1546043displanting
enlisting1038343enlisting
epilating12310973epilating
explanting2045223explanting
fainting123312163_fainting
feinting123410833_feinting
filiating1339253filiating
flinging133310053_flinging
flirting12319013_flirting
fliting113514613_fli_ting
flitting123010883_flitting
foliating1339253foliating
hinting113919223__hinting
impainting1544503impainting
implanting1545323implanting
imprinting1546023imprinting
jointing16248613_jointing
lifting113313273__lifting
lilting83515383__lilting
lining74526803__lin_ing
linking123818253__linking
listing84020593__listing
lunting83817743__lunting
minting103020813__minting
mispainting1645293mispainting
misplanting1645633misplanting
mispointing1645793mispointing
misprinting1646823misprinting
opiating11410093op_iating
opining10311743op_in_ing
paining103920243_pain_ing
paintings12327103_paintings
panting104025423_p_anting
peining104619153_pein_ing
piloting1139693_piloting
pinging113419553_p_inging
pining93726533_p_in_ing
pinking143918943_p_inking
pinning103417853_p_inning
pitting103618873_p_itting
plaining113911553_plain_ing
plaiting113113513_plaiting
planing103418253_plan_ing
planking153513013_planking
planning113610223_planning
plantings12348403_plantings
plating103823073_pl_ating
platting114813033_platting
pleating112916053_pleating
plighting1635563_plighting
plonking15358563_plonking
plotting113011013_plotting
plunging12357673_plunging
plunking15328483_plunking
poinding122510003_poinding
prinking153212453_prinking
printings12268113_printings
punting103318443_p_unting
relenting102716773relenting
relining93218743relin_ing
relinking1458253relinking
relisting102414353relisting
reminting122315103reminting
repainting13128973repainting
replanting1338523replanting
reprinting131510583reprinting
resplitting1444943resplitting
retinting102215253retinting
saining83621393s_ain_ing
salifying1636333salifying
salinizing2047433salinizing
salivating1447443salivating
salting84120793sal__ting
saluting9310553sal_uting
satiating10311813satiating
scanting113914763s_canting
scenting113212813s_centing
scripting1437473scripting
sealifting1444633sealifting
seining84020773s_ein_ing
selecting12310533selecting
seriating10916403seriating
shifting152910383s_hifting
shining113816523s_hin_ing
shinning123211023s_hinning
shirting123213613s_hirting
shitting123212663s_hitting
shoplifting2052143shoplifting
shrining122610853shrin_ing
shrinking1735653shrinking
shunting123610433s_hunting
sifting113014593s__ifting
silencing1245053silencing
silting83320483s__ilting
singing93221423s__inging
sinking123320543s__inking
sinning83918443s__inning
siting74126623s__i_ting
sitting83519633s__itting
skeining1347073skein_ing
skinking12299773s_kinking
skinning13327893s_kinning
skirting13289393s_kirting
skiting123812503s_ki_ting
slanging103413433s_langing
slating83724653s_l_ating
slatting94014233s_latting
sleeting93114163s_leeting
slicing103514643s_li_cing
slicking153712593s_licking
sliding93114553s_li_ding
slighting1436373s_lighting
sliming102913953s_li_ming
slimming13288093s_limming
sliping103314413s_li_ping
slipping133510663s_lipping
slotting92612613s_lotting
smiting103014443s_mi_ting
solating9315593sol_ating
soliciting1346813soliciting
solvating1336443solvating
sopiting11310763sopi_ting
spanking153911973sp_anking
spanning113311083sp_anning
spatting113111763sp_atting
spawning14296913spawn_ing
speaning113512243spean_ing
speciating1548123speciating
speiling113612973spei_ling
speiring113711263spei_ring
spelunking17112003spelunking
spending122712433sp_ending
spicing123914533sp_i_cing
spieling113212523sp_ieling
spiering112713353sp_iering
spiffing17237083sp_iffing
spiking144312883sp_i_king
spiling102919703sp_i_ling
spilling113113943sp_illing
spindling13136273sp_indling
spinnings12294853sp_innings
spiring103918183sp_i_ring
spiriting1238413spiriting
splashing1535703splashing
splaying14219303spl_aying
splint85223283splint___
splinted11369253splint_ed
splinter10329703splint_er
splinters11277923splinters
splintery14264793splintery
splints94511743splint__s
splodging1433303splodging
sploshing1544293sploshing
splurging1333623splurging
spoiling112911553spoi_ling
sponging1238823sp_onging
spooning112811443spoon_ing
sporting112415463sp_orting
spotting112812093sp_otting
spouting113511953sp_outing
spraining1248153sprain_ing
sprigging1435893sprigging
springeing1444373springeing
springings1444663springings
sprinkling1743823sprinkling
spritzing2135393spritzing
sprouting1236943sprouting
spunking15258063sp_unking
spurning11258663spurn_ing
spurting113111633sp_urting
squirting1934793squirting
staining9413373stain_ing
stilting93312403s_tilting
stinging103213453s_tinging
stinking133113543s_tinking
striating10914193striating
stringing1139753stringing
strunting1037873strunting
stunting92811503s_tunting
suiting83419003s_ui_ting
sulfating1338063sulfating
supinating1357833supinating
supplanting1643923supplanting
surprinting1444553surprinting
swinging133411113s_winging
swinking163410323s_winking
syringing1435883syringing
tainting93613583_tainting
tinting84620603__tinting
unlinking1436273unlinking
upbinding1544303upbinding
upflinging1742293upflinging
uplighting1743363uplighting
uptilting1234713uptilting

Search took 9 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 Filter1786911486410.483369960.7
2DLD Change Limit1486412397.79619066.3
3Display Results2392390.1102172.7
 (SQL Overall)1786912398.38921300.6
 
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.