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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

89 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
alkalin1117818(None) 
alkali10127561alkali_
alkalic13146971alkalic
alkaline12168281alkaline
alkalis11148791alkalis
alanin6317272al_anin
alkalies12158542alkalies
alkalify1842822alkalify
alkalise12178042alkalise
alkalize21177632alkalize
alkaloid1345292alkaloid
alkylic16174232alkylic
aalii5316133a__alii
acrasin9311223acrasin
again65218123a_ga_in
akin86328043a_k__in
alan46844083al_a__n
alanine7316863al_anine
alanins7315803al_anins
alation72920553al_ation
albumin1145563albumin
alcaic1039983alca_ic
alcalde10104953alcalde
aldrin7311243al_drin
alevin92511513al_evin
alexin132311483al_exin
alfaki1385383alfaki_
alfakis1475073alfakis
alfalfa1342443alfalfa
alfaquin20112453alfaquin
algal66518223algal__
algin65718763al__gin
aliasing9310073aliasing
alizarin1745863alizarin
alkalinity1752483alkalinity
alkalinize23143023alkalinize
alkalised14155263alkalised
alkalises13167483alkalises
alkalising1545013alkalising
alkalized23146603alkalized
alkalizer22155563alkalizer
alkalizes22157353alkalizes
alkalizing2446133alkalizing
alkaloids1443983alkaloids
alkalosis13124163alkalosis
alkalotic1544023alkalotic
alkane104313323alka_ne
alkanes113812933alkanes
alkanet113714433alkanet
alkie95520033alk__ie
alkine104916803alk__ine
alkyl12518043alkyl__
alkyls13465723alkyl_s
allaying12339313allaying
allelic9118173allelic
allicin949953allicin
allylic12155843allylic
aloin55227423al__oin
alumin8513543al_umin
amain74922913a_ma_in
anilin6417793a_nilin
ankling122912063ank_ling
argali75013753argali_
argalis84214193argalis
attain6311753atta_in
atwain937813atwa_in
balkline1437973balk_line
blain75421793bl_a_in
calkin123515493calk__in
calpain11310413calpa_in
elain55324703el_a_in
flavin1239303fl_avin
gliadin935593gliadin
hyalin122210043_hyalin
jalapin1645923jal_apin
kain85334303__ka_in
kalian10312163__kalian
kalif125021363__kalif
kaolin1039583__kaolin
lain46146283_l_a_in
lanolin7310643lanolin
lapin75222923_l_apin
layin84720333_l_ayin
malkin122913153malk__in
paladin101011773pal_adin
plain74823303pl_a_in
ptyalin1274783ptyalin
silkaline1344243silkaline
slain54923573sl_a_in

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.406440125.6
2DLD Change Limit134027896.75019855.9
3Display Results89890.0332697.0
 (SQL Overall)178691897.18924856.2
 
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.