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 “sparked” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

119 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
sparked14351314(None) 
parked134425141_parked
sharked153613911sharked
spanked143111731spanked
spared95427491spar_ed
sparged113512761sparged
sparker133914361sparker
sparkled15317731sparkled
sparred104512861sparred
barked135027312_barked
carked134024822_carked
charked174814012charked
darked123919632_darked
harked145422552_harked
imparked17264862imparked
larked114519472_larked
marked133921622_marked
narked114116742_narked
packed154822602_packed
paiked135113432_paiked
pared86946762_par_ed
parged104922042_parged
parker124121372_parker
parled94626292_parled
parred95024072_parred
parsed96323892_parsed
parted94228682_parted
perked134617692_perked
porked134717622_porked
reparked15208922reparked
sacked135525212s_acked
scared95227292scar_ed
scarfed134711182scarfed
scarped124314402scarped
scarred104512632scarred
scarted104816122scarted
seared75232842sear_ed
shacked174015392shacked
shanked153212122shanked
shared105829062shar_ed
sharker144313812sharker
sharped134112052sharped
shirked153710462shirked
skanked11338102skanked
slacked143815452slacked
slaked114318272sla_ked
smacked163710992smacked
smarted105012612smarted
smerked14327282smerked
smirked14307232smirked
snacked144013112snacked
snaked115017592sna_ked
snared74824552snar_ed
snarfed11378752snarfed
snarled83612362snarled
soaked114717592soa_ked
soared74324292soar_ed
spaced114517252spa_ced
spackled17297802spackled
spaded103816752spa_ded
spaed85522272spa__ed
spake114322742spa_ke_
spalled103113132spalled
spammed14348522spammed
spanker133612352spanker
spanned104111222spanned
spare75135562spar_e_
sparer84524962spar_er
spares84834552spar_es
sparge94216052sparge_
sparger103613082sparger
sparges104016342sparges
sparid94016932spar_id
spark114920892spark__
sparkers144111312sparkers
sparkier14298032sparkier
sparkle133710212sparkle
sparkler14317982sparkler
sparkles143210492sparkles
sparklet143110592sparklet
sparkly16348132sparkly
sparks124616362spark_s
sparky154511522spark_y
sparoid102311542sparoid
sparse84516342sparse_
sparser94311482sparser
spasmed12296992spasmed
spathed134013182spathed
spatted104014142spatted
spawned13316802spawned
spayed124213612spa_yed
speared104314422spear_ed
specked16329012specked
spiked134915552sp_iked
spired94921862spir_ed
spirted103913072spirted
spoked134413892sp_oked
spooked144510472spooked
spored94821792spor_ed
sported104015432sported
sprayed13398902sprayed
spunked14307782spunked
spurned10339262spurned
spurred103610622spurred
spurted103111972spurted
stacked143416122stacked
staked114621942sta_ked
stalked123811172stalked
stared75429872star_ed
starker114114692starker
starred85013452starred
started84217322started
starved114911572starved
straked125415342straked
swacked173110522swacked
swanked15359542swanked
swarded1238152swarded
swarmed1367482swarmed
warked144421212_warked

Search took 4 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 Filter1786911076710.360496363.9
2DLD Change Limit1076711193.36032044.9
3Display Results1191190.0462587.0
 (SQL Overall)1786911193.76647448.5
 
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.