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

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
aspirin93782(None) 
aspiring1138871aspiring
aspirins1037731aspirins
aspirant1048862aspirant
aspire8612122aspir_e
aspired1068172aspired
aspirer967902aspirer
aspires9612042aspires
spiring103918182_spiring
spirit83519922_spirit
abscisin1243973abscisin
admiring1236133admiring
airing74927503a__iring
airn46433833a__ir_n
aldrin7311243a_ldrin
allicin949953allicin
amidin94015673a_midin
andiron848283andiron
aneurin749833aneurin
anilin6417793a_nilin
antiarin8413893antiarin
apian75018333a_pi_an
apiarian1048323a_piarian
aporia8315863a_poria
apron7318833a_p_ron
ascarid103910723ascarid
ascaris93613323ascaris
ascidia1046683ascidia
ascidian1145633ascidian
ascitic1139323ascitic
asinine7310723as_inine
aspen75216093asp__en
asper75520433asper__
asperity1347223asperity
aspers86220313asper_s
asperse94210663asperse
aspersing1237603aspersing
aspersion1146163aspersion
aspheric1547983aspheric
aspic95114733asp__ic
aspics104211563aspi_cs
aspirants1145233aspirants
aspirata1054993aspirata
aspirate1039943aspirate
aspirating1348363aspirating
aspiration1249993aspiration
aspirers1066493aspirers
aspis74618143asp__is
aspises9611643aspises
aspish114810333aspi_sh
assign736783assi_gn
assuring937773assuring
asteria7316173asteria
astern64815813aster_n
astir55517093astir__
aswirl935093aswir_l
attiring939483attiring
avidin103510843a_vidin
capsicin1455593capsicin
dispirit1149193dispirit
empiric1345963empiric
esprit8312843esp_rit
estrin6315923es_trin
expiring1836253expiring
gastrin839833gas_trin
heparin12410433heparin
inspiring1246183inspiring
inspirit1046283inspirit
mirin75023153__mirin
nonaspirin1253363nonaspirin
pirn67128373__pir_n
purin75527593__purin
respiring12159903respiring
sadiron836043sadiron
saimin8313663_saimin
salicin9311223salicin
saponin9310253saponin
sarin55239253_s_arin
satiric939243satiric
savarin10310003savarin
seisin63715123_seisin
seizin153610843_seizin
serin55434443_s_erin
siren54525823_s_iren
siring75128313_s_iring
sparid94016933_sparid
sparing104823873_sparing
spavin114210653_spavin
speiring113711263_speiring
spicing123914533_spicing
spiering112713353_spiering
spiking144312883_spiking
spiling102919703_spiling
spin66231303_sp__in
spiral83715343_spiral
spirant9814293_spirant
spire75828693_spir_e
spirea84015633_spirea
spired94921863_spired
spirem104214163_spirem
spires84628113_spires
spirier93214073_spirier
spirits94112623_spirits
spiroid10219823_spiroid
spirt75032953_spir_t
spirting112913633_spirting
spirts85317133_spirts
spiry105017353_spir_y
spiting103917623_spiting
sporing104319413_sporing
sprain83614863_sprain
sprig85617743_sp_rig
spring94526013_sp_ring
sprint84526793_sp_rint
sprit76736403_sp_rit
spurn74815453_spur_n
suspiring1245703suspiring
umpiring1336093umpiring
vampiric1742613vampiric

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 Filter1786911340270.1731032896.0
2DLD Change Limit1340271196.78019768.0
3Display Results1191190.0462587.0
 (SQL Overall)1786911196.99925530.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.