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

110 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
sculpins1221647(None) 
sculpin11236651sculpin_
sculping13298941sculping
scalping133410452scalping
sculking15307912sculking
sculling112910992sculling
scullions1154682scullions
sculps104611752sculp__s
sculpting1435002sculpting
sculpts11377062sculp_ts
acyloins1345903acyloins
calkins133814873_calkins
calpains1239763_calpains
caplins113515993_caplins
chopins142312243_chopins
colins85229043_col_ins
collins93419833_collins
cullies94419963_cullies
culling103921303_culling
cullions10219223_cullions
cullis84115993_culli_s
culming123811183_culming
culprits1245583_culprits
cumins103314933_cu_mins
cummins1358963_cummins
cupids11369193_cu_pids
cupping144312383_cupping
cuppings15336053_cuppings
cuspids12427113_cuspids
cuspis105010703_cuspi_s
cutins83919983_cu_tins
duckpins1743693duckpins
gulping11309753_gulping
insculping1542893insculping
inulins7311493inul_ins
lupins84514463_lu_pins
moulins9312703moul_ins
nucleins1046083nucleins
paulins9312613paul_ins
pulping123612323_pulping
pulpits1137243_pulpits
salpians1036763s_alpians
salpids1038193s_alpids
salpinx1636093s_alpinx
scalding12339393scalding
scalepans1343823scalepans
scaling103519373scal_ing
scallions1145783scallions
scalpels12345883scalpels
scalpers123710863scalpers
scalps104315233scalp__s
scampies1439323scampies
scamping153510193scamping
scaping123715693sc_aping
scarfpins1653043scarfpins
scarping133312463scarping
scolding12278913scolding
scoldings13224133scoldings
scooping133610633scooping
scoping123513823sc_oping
scorpions1344213scorpions
scrapies124612473scrapies
scraping133310863scraping
scrapings14255173scrapings
scrupling1435193scrupling
scubaing1335733scubaing
scudding1335673scudding
scuffing17287113scuffing
sculches15176273sculches
sculkers14306933sculkers
sculks123610263scul__ks
scullers103510483scullers
scullion1065633scullion
sculls84613883scul__ls
sculp95314843sculp___
sculped12398253sculp_ed
sculpt104412693sculp__t
sculpted1354883sculpted
sculptor1243843sculptor
sculptors1343993sculptors
scumming15256793scumming
scuppers1446543scuppers
scups95316653scu_p__s
scurries102911483scurries
scurvies13248123scurvies
simlins9311843siml_ins
sirloins836723sirloins
skelping1535973skelping
skulking12245903skulking
skulling13258103skulling
slumping13359973slumping
slurping11278123slurping
souping104215533sou_ping
spins75327983s___pins
stumping13289083stumping
stupids1035273stu_pids
suldans8299723s_uldans
sulfids1137293s_ulfids
sulkies114315763s_ulkies
sulking124514313s_ulking
sullies74122233s_ullies
sulphas1236243s_ulphas
sulphids1444373s_ulphids
sultans72411833s_ultans
supine84216693s_u_pine
supines94216383s_u_pines
supping123814533s_upping
sylvins13246243s_ylvins
unpins82312383__unpins
vulpine1235903_vulpine

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 Filter1786911461620.1701051123.5
2DLD Change Limit1461621107.90618487.5
3Display Results1101100.0462391.3
 (SQL Overall)1786911108.12222000.9
 
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.