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

193 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
splitting123656(None) 
slitting93012581s_litting
spitting113012321sp_itting
splatting1235981splatting
splinting1238191splinting
flitting123010882_flitting
pitting103618872_p_itting
platting114813032_platting
plotting113011012_plotting
resplitting1444942resplitting
shitting123212662s_hitting
sitting83519632s__itting
slatting94014232s_latting
slotting92612612s_lotting
spatting113111762sp_atting
spirting112913632sp_irting
spiting103917622sp_i_ting
splicing1338962spli_cing
splining11310772spli_ning
spoliating1366962spoliating
spotting112812092sp_otting
sprinting12310032sprinting
spritzing2135392spritzing
uplifting1534962uplifting
admitting1345033admitting
allotting1046503allotting
befitting15236623befitting
belittling1343193belittling
bitting103717293__bitting
blatting114111653_blatting
blitzing2035903_blitzing
blotting113910433_blotting
clotting113110643_clotting
coplotting1555953coplotting
delisting112710503delisting
demitting13239073demitting
earsplitting1551383earsplitting
emitting112410353_emitting
enlisting1038343enlisting
epilating12310973epilating
filiating1339253filiating
fitting113516563__fitting
flatting123511253_flatting
flinting123412343_flinting
flirting12319013_flirting
fliting113514613_fli_ting
foliating1339253foliating
fritting123510703_fritting
gitting93215703__gitting
glinting103210053_glinting
glitzing1934973_glitzing
glutting10247643_glutting
gritting10309983_gritting
hitting113017273__hitting
inletting1087873inletting
kitting123214443__kitting
knitting13257023_knitting
letting83218533__letting
lifting113313273__lifting
lilting83515383__lilting
linting83820983__linting
listing84020593__listing
lotting82917753__lotting
militating1348823militating
omitting11217743_omitting
opiating11410093op_iating
painting113614423_painting
patting103722343_p_atting
petting103720953_p_etting
piloting1139693_piloting
pithing134014053_p_ithing
pittings11349123_p_ittings
pitying132910243_p_itying
plaiting113113513_plaiting
planting113515383_planting
plating103823073_pl_ating
pleating112916053_pleating
plighting1635563_plighting
plinking153611243_plinking
plotzing20276153_plotzing
pointing112813683_pointing
potting103720893_p_otting
printing113216083_printing
putting103218573_p_utting
quitting18228833_quitting
refitting132811123refitting
reletting102713943reletting
relisting102414353relisting
remitting122412623remitting
replotting1357043replotting
resitting103414873resitting
sainting93215733s_ainting
salifying1636333salifying
salivating1447443salivating
salting84120793sal__ting
saluting9310553sal_uting
sanitating1149653sanitating
satiating10311813satiating
scatting113311813s_catting
scripting1437473scripting
sealifting1444633sealifting
selecting12310533selecting
seriating10916403seriating
setting83621393s__etting
shifting152910383s_hifting
shirting123213613s_hirting
shoplifting2052143shoplifting
shotting123012383s_hotting
shutting12309693s_hutting
sifting113014593s__ifting
silting83320483s__ilting
siting74126623s__i_ting
sittings9339733s__ittings
skirting13289393s_kirting
skiting123812503s_ki_ting
sklenting1475123sklenting
slanting94115093s_lanting
slating83724653s_l_ating
slattings10346073s_lattings
sleeting93114163s_leeting
slicing103514643s_li_cing
slicking153712593s_licking
sliding93114553s_li_ding
slighting1436373s_lighting
sliming102913953s_li_ming
slimming13288093s_limming
slinging103312863s_linging
slinking133412983s_linking
sliping103314413s_li_ping
slipping133510663s_lipping
slittier837003s_littier
smiting103014443s_mi_ting
smutting11278063s_mutting
solating9315593sol_ating
soliciting1346813soliciting
solvating1336443solvating
sopiting11310763sopi_ting
speciating1548123speciating
spectating1546623spectating
speiling113612973spei_ling
speiring113711263spei_ring
spicing123914533sp_i_cing
spieling113212523sp_ieling
spiering112713353sp_iering
spiffing17237083sp_iffing
spiking144312883sp_i_king
spiling102919703sp_i_ling
spilling113113943sp_illing
spinning113310813sp_inning
spiring103918183sp_i_ring
spiriting1238413spiriting
splashing1535703splashing
splattering1454543splattering
splaying14219303spl_aying
splintering1444293splintering
splitter10348443splitt_er
splitters11307323splitters
splodging1433303splodging
sploshing1544293sploshing
splotching1842863splotching
splurging1333623splurging
spluttering1463363spluttering
spoiling112911553spoi_ling
sporting112415463sp_orting
spouting113511953sp_outing
sprattling1363053sprattling
sprigging1435893sprigging
springing1338743springing
sprouting1236943sprouting
spurting113111633sp_urting
squatting1934513squatting
squinting1936223squinting
squirting1934793squirting
stetting93410713s_tetting
stilting93312403s_tilting
stinting93415743s_tinting
stotting92811163s_totting
striating10914193striating
strutting1037003strutting
subletting1346273subletting
submitting1544973submitting
suiting83419003s_ui_ting
sulfating1338063sulfating
swatting12309593s_watting
swotting12268483s_wotting
twitting12307223_twitting
unfitting1336423unfitting
unwitting1335583unwitting
uplighting1743363uplighting
uplinking1634623uplinking
upsetting1275563upsetting
uptilting1234713uptilting
witting113417063__witting

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 Filter1786911486410.423422437.4
2DLD Change Limit1486411937.45319943.8
3Display Results1931930.0762539.5
 (SQL Overall)1786911937.95222471.2
 
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.