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

329 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
apneal8341112(None) 
anneal64812291anneal
apnea73413411apnea_
apneas83211381apneas
apnoeal956191apnoeal
appeal103911611appeal
adnexal1543822adnexal
anal48037522a_n_al
anear55420322a_near
annal56520762a_nnal
anneals7449942anneals
annual64710702annual
apeak115513452ap_eak
apical10913902apical
apneic1078622apneic
apnoea867092apnoea_
apnoeas946352apnoeas
apodal9289832apodal
apogeal1045622apogeal
appal95315222ap_pal
appeals11378672appeals
appear10379342appear
appel94615892appe_l
apteral9311522apteral
areal55928732a_real
balneal936572balneal
cuneal8611512cuneal
lineal65616022lineal
paleal84716672paleal
panel76023622pane_l
peal68648102_p_eal
penal75228372_penal
pineal84817682pineal
tineal66216162tineal
vineal94814742vineal
aal39058673a___al
abeam9316533a_beam
aboral8314373aboral
abseil837183abseil
acetal84314903acetal
acne66625873acne__
acned87520673acne_d
acnes75922623acne_s
actual8311023actual
adenyl1035023adenyl
adnexa1433673adnexa
adrenal838263adrenal
aecial84817313aecial
aeneus61111143aeneus
aerial64625713aerial
agleam9158623agleam
agnail739533agnail
agonal7410053agonal
ahead96817053a_head
ainsell796393ainsell
akela9311343a_kela
algal66518223a_lgal
allheal1044553allheal
amnia75918643amnia_
amoral8314633amoral
ana39559833a_n_a_
anas46649863a_n_as
anconeal1045593anconeal
ane37866953a_ne__
anears63717183a_nears
anele55628833a_nele
anent54931843a_nent
anes45255933a_ne_s
anew76623133a_ne_w
anga56831353a_nga_
angas65827983a_ngas
angel65019563a_ngel
anil46437433a_n_il
animal85016253animal
anlas55626933a_nlas
anna45529013a_nna_
annals66415923a_nnals
annas55824883a_nnas
annealed936343annealed
annealer845503annealer
annex12310883anne_x
annexe1337813annexe
annuals7388193annuals
annul55813383a_nnul
anoa45634473a_noa_
anoas57226493a_noas
anodal72512123anodal
ansa45927773a_nsa_
ansae55720973a_nsae
anta46839583a_nta_
antae56828293a_ntae
antas55432033a_ntas
antral65719413antral
anural65714743anural
anvil82712603a_nvil
aortal65217513aortal
ape57251183ap_e__
aped78538153ap_e_d
apeek114711873ap_eek
aper66336233ap_e_r
apers76629133ap_ers
apery106517903ap_ery
apes66047433ap_e_s
apetaly1237253apetaly
apex137220213ap_e_x
apian75018333ap_ian
apicals1159923apicals
apiece10510083apiece
apnoeic1147613apnoeic
apogean1045443apogean
appall10379743appall
appals104812943ap_pals
appealed1335603appealed
appealer1245743appealer
appears11308953appears
appease1137913appease
appels104312793appels
append1138273append
apres75426403apre_s
apse67725383apse__
apses76823913apse_s
apsidal1046703apsidal
apter76120203apte_r
aptest82917513aptest
aptness9268573aptness
area45843393a_rea_
areae55229743a_reae
areas55935773a_reas
arena55323813arena_
arenas65021993arenas
argal65023393a_rgal
ariel55228973arie_l
arrear6310253arrear
arsenal739383arsenal
artal55525473a_rtal
artel56122743arte_l
arval86017013a_rval
asea46327183a_sea_
astral66919283astral
atabal839743atabal
atonal6514023atonal
atrial65418943atrial
audial7312993audial
aural54428963a_ural
avowal1246323avowal
awned96615953awne_d
axal116520493a__xal
axel115222073a_xe_l
axial124515193a_xial
axonal1347653axonal
axonemal1743543axonemal
azonal1568273azonal
banal75925993ban_al
benzal1739643benzal
binal75323823bin_al
boreal84817213boreal
canal75428043can_al
cannel84216403canne_l
cantal84122033cantal
capital112311523capital
caporal11410943caporal
carnal83919203carn_al
cental84420963cental
cereal8315833cereal
cineol8108203cineol
conceal113313013conceal
congeal104011683congeal
corneal94414503corneal
darnel74312183darne_l
deal56347413__deal
denial74720513denial
dental74319173dental
dynel9569853dyne_l
dyspneal1442103dyspneal
ennead736253ennead
epical10413393epical
epigeal1046243epigeal
eupnea835033eupnea_
eupneas935233eupneas
faunal94711593faun_al
feal713940423__feal
final83922033fin_al
finial92814183finial
fontal9313143fontal
foveal1237703foveal
funeral1037623funeral
fungal10388733fungal
general81010933general
genial74917613genial
gingal81010153gingal
grapnel1035603grapne_l
heal75645693__heal
ideal65716393_ideal
ileal56118083_ileal
irreal657833irreal
jingal1498593jingal
knead10429663_knead
kneel95012033_kneel
knell94210923_knell
lacteal966813lacteal
lapel73716683lap_e_l
leal46043273__leal
lienal63912783lienal
linear65113343linear
loreal63814313loreal
luteal64411483luteal
manual8313463manual
meal65643173__meal
menial84223033menial
mensal84615663mensal
mental84521603mental
mineral9312733mineral
neap66927013__neap
near45236503__near
neat46356783__neat
oatmeal944973oatmeal
opal66923523op__al
ordeal779253ordeal
osteal6312963osteal
paean77222723_paean
pal56761673_p__al
palea75028663palea_
paleae84820293paleae
palpal104112053palpal
panda85022613panda_
pandas95521963pandas
pane64950293pane__
paned85437183pane_d
panels84716523panels
panes76148693pane_s
panful1179743panful
panga85323533panga_
pangas99921103pangas
papal95820673_papal
papyral1445773papyral
parral85517533parral
pascal10812373pascal
pausal81511963pausal
pea56657243_p_ea_
peag75431343_p_eag
peak106535203_p_eak
peals75235493_p_eals
pean66147173_p_ean
pear69745233_p_ear
pearl75324463_p_earl
peas65755063_p_eas
peat65967933_p_eat
pedal86022503_pedal
peel65535613_p_eel
penial84120893penial
petal76526893_petal
phial10313203_phial
pial65636703_p_ial
pibal95217323_pibal
pical95524373_pical
pineals93212843pineals
pinnal84814273pinnal
pipal95118353_pipal
plea66830603_plea_
plead85818463_plead
pleas75627033_pleas
pleat74734473_pleat
plexal1536843_plexal
pupal97616873_pupal
rappel104211953rappe_l
real45750293__real
renal55929503ren_al
renewal1038703renewal
rental63922023rental
repeal84718283repeal
reseal64819643reseal
reveal94115053reveal
sandal73317283sandal
saphead1357773saphead
seal45654373__seal
sendal73314993sendal
sheal84927703_sheal
sneak96016173_sneak
sneap75514823_sneap
snell54517303_snell
speak114618673sp_eak
spean74620513sp_ean
spear75821063sp_ear
speel74420763sp_eel
speil75618643sp_eil
spell75020303sp_ell
spheral1238423spheral
spiel74623913spie_l
spinal84915313spinal
spinel85317333spine_l
spiral83715343spiral
spital83813873spital
sponsal946343sponsal
sporal82915453sporal
spread9312533spread
squeal1538023squeal
steal56125473_steal
tapetal938273tapetal
tarnal63716503tarn_al
teal45546503__teal
thenal92712423thenal
tincal83913363tincal
tinea54923163tinea_
tineas64616483tineas
tonal53724303ton_al
unreal64414453unreal
unseal63315473unseal
upbear1096493upbear
upbeat10911513upbeat
upheap13105213upheap
upleap10106843upleap
uprear8168793uprear
uptear896783uptear
upwell11285803upwell
ureal56722683_ureal
usnea539393usnea_
usneas638333usneas
uveal84411073_uveal
vandal103713833vandal
veal76936813__veal
venal85523213ven_al
venial94218283venial
vinal85725813vin_al
weal75838683__weal
wheal115716183_wheal
xenial133414903xenial
zeal135530333__zeal
zoeal144813783_zoeal
zonal145116853zon_al

Search took 6 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 Filter1786911127160.376475242.0
2DLD Change Limit1127163294.89023050.3
3Display Results3293290.1102990.9
 (SQL Overall)1786913295.37633238.7
 
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.