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

92 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
apsidal104670(None) 
capsidal1345621capsidal
apical10913902ap_ical
apodal9289832ap_odal
apsides103911302apsides
acaudal1045783acaudal
achiral12109183achiral
actinal9312293actinal
admiral1046363admiral
aecial84817313aeci_al
aecidial1147253aecidial
aerial64625713aeri_al
aestival1145483aestival
affinal1336443affinal
affixal2043763affixal
albinal937813albinal
alidad838883a_lidad
alodial899953alodial
amidol9489573a_midol
anginal8310163anginal
animal85016253a_nimal
anodal72512123a_nodal
aphid115515393aphid__
aphides134711203aphides
aphidian1445533aphidian
aphids125110843aphid_s
apian75018333ap_i_an
apicals1159923ap_icals
apneal83411123ap_neal
apnoeal956193apnoeal
apogeal1045623apogeal
appal95315223ap__pal
appeal103911613ap_peal
apsis75718293apsi__s
apteral9311523apteral
arrival1037563arrival
arsenal739383arsenal
aside65122083a_sid_e
asides75118873a_sides
astral66919283a_stral
atrial65418943atri_al
audial7312993audi_al
austral73411513austral
axial124515193a_xi_al
basidial1145623basidial
basinal9310033basinal
bridal9511453_bridal
candidal12367733candidal
capital112311523cap_ital
capsid11312413capsid__
capsids1239333capsid_s
cotidal1038463cotidal
cuspidal1343473cuspidal
epical10413393ep_ical
espial839543espi_al
fluidal1144653fluidal
geoidal936713geoidal
haptical1547343haptical
hyoidal1444803hyoidal
lipoidal1144473lipoidal
mesial84818083mesi_al
misdial1039643misdial
musical1139553musical
nasial6413283nasi_al
nidal65217103__nidal
oppidan1243463oppidan
optical1149863optical
optimal1145783optimal
ovoidal1144023ovoidal
paginal10269493paginal
paludal1035683paludal
pascal10812373pas_cal
paschal14157243paschal
pedal86022503_p_edal
phial10313203_phi_al
pial65636703_p_i_al
pibal95217323_p_ibal
pical95524373_p_ical
pipal95118353_p_ipal
plical10411683_plical
primal104014623_primal
residual9245443residual
sial45938833__si_al
sisal54217733__sisal
spinal84915313sp_inal
spiral83715343sp_iral
spital83813873sp_ital
tidal64516443__tidal
upside9289803upsid_e
upsides10319633upsides
vesical12159813vesical
zooidal1745093zooidal

Search took 7 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 Limit134027925.98322401.3
3Display Results92920.0303066.7
 (SQL Overall)178691926.41927837.8
 
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.