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

186 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
apteral931152(None) 
antheral1149392antheral
antral65719412ant_ral
apneal83411122apne_al
appeal103911612appe_al
apter76120202apter__
apteria9312912apteria
apteryx1942382apteryx
arterial8313622arterial
asternal858312asternal
astral66919282ast_ral
chapteral1644682chapteral
dipteral1146992dipteral
enteral73516432enteral
lateral7313562lateral
literal7613262literal
paternal1038332paternal
spheral1238422spheral
abettal946073abettal
aboral8314373a_boral
acetal84314903a_cetal
achiral12109183achiral
actinal9312293actinal
actual8311023act_ual
admiral1046363admiral
adnexal1543823adnexal
adrenal838263adrenal
aerial64625713a__erial
aethereal1244593aethereal
after85719793after__
afters94717073after_s
aftertax1843233aftertax
alter54828503alter__
alterable1149163alterable
alterably1447203alterably
alterant8614963alterant
altered83215733altered
alterer72713993alterer
alters64924223alter_s
amoral8314623a_moral
amphoral1565623amphoral
amtrac10109123amt_rac
anneal64812293anne_al
antennal856353antennal
anthrax1757153anthrax
antra56521923ant_ra_
anural65714743a_nural
apeak115513453ap_e_ak
aper66336233ap_er__
apercu1057383ap_ercu
apers76629133ap_er_s
apertural1144093apertural
apery106517903ap_er_y
apetaly1237253ap_etaly
apical10913903ap_ical
apnea73413413apne_a_
apneas83211383apne_as
apnoeal956193apnoeal
apodal9289823ap_odal
apogeal1045613apogeal
appal95315223ap__pal
apparat11711713apparat
apparel1146003apparel
appeals11378673appe_als
appear10379343appe_ar
appears11308953appears
appel94615893appe__l
apsidal1046693apsidal
apterium1249133apterium
apterous10410463apterous
aptest82917513apte_st
areal55928733a_re_al
arsenal739383arsenal
artal55525473art__al
artel56122743arte__l
arterials949683arterials
artery9911453arter_y
aster55434893aster__
asteria7316173asteria
asterias8317003asterias
astern64815813aster_n
asters65631603aster_s
astrals75515243ast_rals
astray95615543ast_ray
atabal839743a_tabal
atonal6514023a_tonal
atrial65418943a_trial
augural856403augural
aural54428963a__ural
auroral7310473auroral
austral73411513austral
bacterial1348353bacterial
butyral1245713butyral
cameral11311263cameral
caporal11410943cap_oral
carceral1247193carceral
cateran9313763cateran
citral81113883cit_ral
diptera1037203diptera_
dipteran1146193dipteran
entera64216833entera_
enthral103410933enthral
ephoral1248403ephoral
estral64716513est_ral
eternal72910893_eternal
external1577223external
falderal12104803falderal
federal1148533federal
feral85424653__feral
funeral1037623funeral
futural1037283futural
gastral8329553gast_ral
general81010933general
gomeral1038833gomeral
haptical1547343haptical
humeral1238563humeral
integral946783integral
internal8414073internal
interval11710443interval
inthral10249463inthral
lacteal966813lacte_al
laterad8310833laterad
laterals8312743laterals
liberal9310193liberal
literals8312283literals
litoral7610763litoral
luteal64411483lute_al
material10314093material
maternal1047803maternal
mineral9312733mineral
mitral81314323mit_ral
natural739513natural
numeral939083numeral
opera7313573op_era_
operas8312453op_eras
optical1149863optical
optimal1145783optimal
osteal6312953oste_al
paleal84716673pale_al
papyral1445773papyral
parral85517533_parral
pastoral10310483pastoral
pastural1038413pastural
patella938953patella
pater74740723pater__
paters84935823pater_s
patrol83213023pat_rol
peal68648103_p_e_al
pearl75324463_p_earl
pedal86022503_p_edal
penal75228373_p_enal
peril75425953_p_eril
petal76526893_p_etal
petrale9312623_petrale
petrel83111533_petrel
petrol82714063_petrol
pleural956673_pleural
plexal1536833_plexal
plural839823_plural
preoral9312673_preoral
pterin81014153_pterin
pteryla1243303_pteryla
puberal1147773puberal
raptorial1147433raptorial
retral64419743ret_ral
ruderal837373ruderal
santera7311303santera_
santeras8311053santeras
scleral937863scleral
seral56336383__seral
several1039533several
spiral83715343sp_iral
sporal82915453sp_oral
steal56125473_ste_al
sternal73411903_sternal
sterol6613323_sterol
sutural7310223sutural
tapetal938273tap_etal
teal45546503__te_al
tepal76319583__tepal
terai53525483__terai
tergal72912833__tergal
uptear896783upte_ar
uptears9106443uptears
ureteral856233ureteral
veteran1039343veteran

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.1561145455.1
2DLD Change Limit1340271866.78019768.0
3Display Results1861860.0632952.4
 (SQL Overall)1786911866.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.