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

125 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
sparkish1727697(None) 
darkish1537942_darkish
larkish1439082_larkish
parish115022352_par_ish
perkish16258822_perkish
sparkier14298032sparkier
sparkiest15188092sparkiest
sparkily1735022sparkily
sparking152812542sparking
sparks124616362spark_s_
spearfish1743602spearfish
spookish1744642spookish
starfish1438082starfish
bearish123013273bear_ish
blackish1976713blackish
boarfish1635753boarfish
boarish123911913boar_ish
brackish1987613brackish
carlish12312763_carlish
clerkish1744263clerkish
crankish1736513crankish
dwarfish1843783dwarfish
garfish14179203_garfish
garish104516923_gar_ish
garnish111610843_garnish
gawkish1835833_gawkish
hawkish2036553_hawkish
largish1138603_largish
marish114319053_mar_ish
mawkish1935823_mawkish
oarfish13158613_oarfish
palish114718273_pa_lish
panfish15229973_panfish
pariah114320583_par_iah
paris75145943_par_is_
parkas125018023_parkas_
parking143423043_parking
parks116134463_park_s_
parvis116114803_parvis_
parvise124211693_parvise
peakish16268873_peakish
peckish18227293_peckish
perish114619063_per_ish
pinkish16279113_pinkish
prankish1737023prankish
puckish18237213_puckish
punkish16257693_punkish
quackish2654383quackish
quirkish2442993quirkish
rakish134313963_ra_kish
rankish14510383_rankish
sakis95323673s_a_kis_
saltish10312163s_altish
saris54544953s_ar_is_
sarkier113413313s_arkier
sarkiest123615063s_arkiest
sarks96632463s_ark_s_
sawfish1637683s_awfish
scampish1744893scampish
serfish1348973s_erfish
shariah132210533shar_iah
sharking163912973sharking
sharks135019723shark_s_
shortish1437423shortish
sickish1638423s_ickish
skirmish1743263skirmish
slavish1338233sla_vish
smallish1346573smallish
snappish1545233snappish
snarkier12336513snarkier
snarkiest13207633snarkiest
snarkily1534583snarkily
snarks104815733snark_s_
sourish10310693sour_ish
spadefish1842953spadefish
spahis11310383spa_his_
spanking153911973spanking
spanks124514123spank_s_
sparers94519613sparers_
spares84834553spar_es_
sparest94616423spar_est
sparges104016343sparges_
sparging122611133sparging
sparid94016933spar_i_d
sparids103512123spar_ids
sparing104823873spar_ing
spark114920893spark___
sparked143513143spark_ed
sparker133914363spark_er
sparkers144111313sparkers
sparkle133710213spark_le
sparkled15317733sparkled
sparkler14317983sparkler
sparkles143210493sparkles
sparklet143110593sparklet
sparklier1554363sparklier
sparkliest1644573sparkliest
sparkling16226353sparkling
sparkly16348133spark_ly
sparky154511523spark__y
sparlike1437673sparlike
sparling112714533sparling
sparoid102311543sparoi_d
sparoids11218713sparoids
sparrier10329143sparrier
sparriest11198783sparriest
sparring113112223sparring
spars75431543spar__s_
sparse84516343spar__se
sparsest1048813sparsest
sparsity1345463sparsity
spartina1037983spartina
squarish2047323squar_ish
stablish1348343stablish
standish1238543standish
starkest1239723starkest
stockish17186043stockish
swainish1444753swainish
swampish1844173swampish
tarnish101611873_tarnish
tartish101512633_tartish
varnish13169533_varnish
warmish1538373_warmish
weakish17217173wea_kish
wearish132310153wear_ish

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 Limit1461621257.09620597.8
3Display Results1251250.0462717.4
 (SQL Overall)1786911257.56223630.1
 
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.