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

131 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
imparked1726486(None) 
imbarked17254061imbarked
imparted13248061imparted
embarked17205222embarked
impacted15286352impacted
impaired1335142impaired
impaled12288512impa_led
impark14287072impark__
imparks15276662impark_s
imparter12357542imparter
impasted13297552impasted
impawned1643442impawned
impearled1442862impearled
imported13308692imported
marked133921622_m_arked
parked134425142__parked
reparked15208922reparked
sparked143513142_sparked
barked135027313__barked
biparted1335133biparted
carked134024823__carked
charked174814013_charked
compared153811823compar_ed
comparted16338423comparted
darked123919633__darked
debarked16175833debarked
demarked16187223demarked
departed1238823departed
disparted1338853disparted
embanked17253883embanked
embarred13174803embarred
empaled12288953empa_led
harked145422553__harked
imaged1097763im_a_ged
imaret81121233im_ar_et
imbalmed1543293imbalmed
imbark14347863imbark__
imbarks15326613imbark_s
imbrued1234693im_brued
immerged1444023immerged
immersed1344833immersed
immured1235063immur_ed
impacter14296573impacter
impainted1454773impainted
impairer1244863impairer
impale102811663impa_le_
impaler11298393impa_ler
impales113311763impa_les
impanel1137093impa_nel
impaneled1443563impaneled
imparity1546783imparity
imparking1834713imparking
impart102715143impar__t
imparters13276573imparters
imparts11298533impar_ts
impasse11246463impasse_
impasses12257523impasses
impaste11258003impaste_
impastes12238193impastes
impastoed14242803impastoed
impavid1544553impa_vid
impeached1942983impeached
imped105117983imp___ed
impeded13418183imp_eded
impelled1336073impelled
impended1435953impended
imperiled1445493imperiled
impinged14275123impinged
implanted1475493implanted
impled113812513imp__led
implied1238623imp_lied
imploded14145073imploded
implored13135373implored
imponed12279453imp_oned
importer12308913importer
imposed123110293imp_osed
imposted13257403imposted
improved1644773improved
impugned14333923impugned
impulsed1334003impulsed
impure1038383impur_e_
impurer1136483impur_er
imputed1236533imp_uted
inarmed10268673i_narmed
irked104510923i___rked
jampacked2742053jampacked
larked114519473__larked
marker124420393_m_arker
market123226043_m_arket
marled95523173_m_arled
marred95421043_m_arred
marted94425213_m_arted
masked134316523_m_asked
mismarked1845243mismarked
misparsed1446253misparsed
misparted1437263misparted
narked114116743__narked
packed154822603__packed
paiked135113433__paiked
pared86946763__par_ed
parged104922043__parged
parker124121373__parker
parled94626293__parled
parred95024073__parred
parsed96323893__parsed
parted94228683__parted
perked134617693__perked
porked134717623__porked
ramparted1443543ramparted
remarked15209243remarked
repacked17188743repacked
reperked15177793reperked
sharked153613913_sharked
simpered1338253simper_ed
smacked163710993sm_acked
smarted105012613sm_arted
smeared104510623smear_ed
smerked14327283sm_erked
smirked14307233sm_irked
spanked143111733_spanked
spared95427493_spar_ed
sparged113512763_sparged
sparker133914363_sparker
sparkled15317733_sparkled
sparred104512863_sparred
umpired1235783umpir_ed
unmarked15248813unmarked
unpacked17268663unpacked
unparted11310823unparted
upmarket1644663upmarket
warked144421213__warked

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.500357382.0
2DLD Change Limit1461621317.20320291.8
3Display Results1311310.0462847.8
 (SQL Overall)1786911317.74923059.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.