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

152 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
stippling147517(None) 
stipplings1582371stipplings
stoppling1474961stoppling
tippling13196701_tippling
crippling1644092crippling
rippling13197572_rippling
shipping163611252shipp_ing
sipping123117432s_ipp_ing
skipping17297602skipp_ing
slipping133510662slipp_ing
snipping13308852snipp_ing
stapling112813152st_apling
stepping13329072stepp_ing
stickling1647002stickling
stifling122110912sti_fling
stilling93415322sti_lling
stopping133611412stopp_ing
stripling1257782stripling
stripping1436492stripp_ing
suppling1359042s_uppling
tipping122814972_tipp_ing
toppling13197352_toppling
blipping15306803blipp_ing
chipping18389793chipp_ing
clipping15349153clipp_ing
crimpling1645343crimpling
dappling1436843_dappling
dimpling14199023_dimpling
dipping134014833_dipp_ing
dripping14278033dripp_ing
estopping1434793estopp_ing
flipping16307663flipp_ing
gipping133813123_gipp_ing
grappling1544993grappling
gripping14277543gripp_ing
hipping153915103_hipp_ing
hirpling1467223_hirpling
hoppling16206763_hoppling
kipping163311873_kipp_ing
lipping123016073_lipp_ing
nipping123412873_nipp_ing
pipping113414743_pipp_ing
poppling12227323_poppling
quipping2234843quipp_ing
rimpling13219663_rimpling
ripping123315743_ripp_ing
sailing83927373sai__ling
sampling13510643s_ampling
sapling103217863s__apling
sapping123519313s_app_ing
scrupling1435193scrupling
shieling123512403shi_eling
shilling123315383shi_lling
shingling14136973shingling
shippings17275683shipp_ings
shopping163611293shopp_ing
sibling10814423s_i_bling
sickling152910333s_ickling
sideling101012183s_ideling
sidling9915423s_i_dling
singling101913003s_ingling
siping94220633s_i_p_ing
sizzling17225783s_izzling
skiffling2043103skiffling
skilling132911333ski_lling
skimping17306243skimp_ing
skippering1943673skippering
skirling13249063ski_rling
slapping133510843slapp_ing
sliping103314413sli_p_ing
slopping133811423slopp_ing
smiling103915443smi__ling
snapping13349653snapp_ing
sniffling1644093sniffling
sniggling1244413sniggling
sniping103712053sni_p_ing
sniveling1336033sniveling
soiling83422323soi__ling
sopping123917203s_opp_ing
spieling113212523spi_eling
spiling102919703s__piling
spilling113113943spi_lling
spindling13136273spindling
spiraling1237953spiraling
stabling112913653st_abling
staling83925423st__aling
stalling95116703st_alling
stamping133310963stamp_ing
starling93017123st_arling
startling1037373startling
stealing93416603st_ealing
steeling93615143st_eeling
steeping113412583steep_ing
sterling93615553st_erling
sticking153513463sti_cking
stiffing15248703sti_ffing
stilting93312403sti_lting
stimying1437503sti_mying
stinging103213453sti_nging
stinking133113543sti_nking
stinting93415743sti_nting
stipple1146623stippl__e
stippled1345303stippl_ed
stippler1235543stippl_er
stipplers1334453stipplers
stipples1247023stippl_es
stipulating1445163stipulating
stirring9299653sti_rring
stitching1547103stitching
stithying1643703stithying
stomping13309763stomp_ing
stooling93113133st_ooling
stooping113012363stoop_ing
stoping103716623st_op_ing
stoppering1544613stoppering
strapping1436993strapping
streeling10189483streeling
strickling1744953strickling
striping112612523strip_ing
striplings1344183striplings
strolling10238793strolling
stropping1436933stropping
stumbling1435003stumbling
stumping13289083stump_ing
styling112910653st__yling
supping123814533s_upp_ing
supplying1774043s_upplying
swapping16348673swapp_ing
swilling123511933swi_lling
swindling14135833swindling
swingling14156203swingling
swiping13319823swi_p_ing
swirling12249143swi_rling
swiveling1634573swiveling
swizzling2142493swizzling
swopping16377963swopp_ing
tapping123317133_tapp_ing
tickling15309433_tickling
tiling73426553_ti__ling
tilling83522783_ti_lling
tingling102210823_tingling
tinkling13239233_tinkling
tirling83315733_ti_rling
titling83715793_ti_tling
topping123514623_topp_ing
tripling112712553_tripling
tripping133210923tripp_ing
tupping123411663_tupp_ing
whipping19328173whipp_ing
wimpling16207483_wimpling
yipping152710683_yipp_ing
zipping212910573_zipp_ing

Search took 7 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 Limit1486411526.43623095.2
3Display Results1521520.0632412.7
 (SQL Overall)1786911526.92225814.9
 
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.