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

284 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
anorak103892(None) 
anoraks1137601anoraks
aboral8314372aboral
agora6914332agora_
agorae7511202agorae
agoras7613342agoras
amoral8314632amoral
angora71111572angora_
angoras8811362angoras
anoa45634472ano_a_
anoas57226492ano_as
anodal72512122anodal
antra56521922antra_
antral65719412antral
anural65714742anural
anuran64313242anuran
arak86929572a__rak
abnormal1244093abnormal
aboard9312613aboard
aboma91114603aboma_
abomas101113583abomas
abort76133583abor_t
aborts84916183aborts
abroad9310943abroad
acock132110213aco_ck
acorn75616623acor_n
acorns85013013acorns
adore65723673ador_e
adored84714243adored
adorer74713453adorer
adores74420723adores
adorn64917093ador_n
adorns74212613adorns
affray1534973affray
afore85818603afor_e
agonal7410053agonal
agorot7415003agorot
ahorse9311513ahorse
ajowan1634893ajowan
aloha8513623aloha_
alohas9411703alohas
amok10217403amo__k
amort75832203amor_t
amtrac10109133amtrac
amtrack15107393amtrack
ana39559833an__a_
anabas8314083anabas
anagram1058193anagram
anal48037523an__al
anarch11310393anarch
anas46649863an__as
anconal939423anconal
andro6314163andr_o
andros7313303andros
anear55420323an_ear
anears63717183anears
anergy10156863anergy
anga56831363an_ga_
angary10311323angary
angas65827993an_gas
angry9310873angr_y
anima74620073anima_
animal85016253animal
animas84418723animas
anlas55626933an_las
anna45529013an_na_
annal56520763an_nal
annas55824883an_nas
anneal64812293anneal
annona648873annona_
annonas738793annonas
annual64710703annual
anode65021043ano_de
anodes74418763anodes
anodic92813133anodic
anoint6423633anoint
anole55330383ano_le
anoles64827433anoles
anomaly1238843anomaly
anomic102516303anomic
anomie83215963anomie
anomy105113393ano_my
anon46134853ano__n
anonym1136383anonym
anopia83412393anopia
anopias92412483anopias
anorexy1743563anorexy
anoxia133510023anoxia
anoxias14259113anoxias
anoxic152610673anoxic
ansa45927773an_sa_
ansae55720973an_sae
anta46839583an_ta_
antae56828293an_tae
antas55432033an_tas
anthrax1757153anthrax
antiar6317173antiar
antick124814583antick
antre55224523antr_e
antres65021003antres
antrum8611313antrum
anurans73810553anurans
anuria6313123anuria
anurias7312253anurias
anuric8812113anuric
anyway1534803anyway
aorta55922573a_orta
aortae65115473a_ortae
aortal65217513a_ortal
aortas65417783a_ortas
apeak115513453a_peak
apnoea867093apnoea_
apnoeal956193apnoeal
apnoeas946353apnoeas
apodal9289833apodal
aporia8315863aporia
aporias9315153aporias
aport75432173apor_t
araks94820883a__raks
ark77044963a__r_k
aroma71220143aroma_
aromas81018613aromas
arrack121110253a_rrack
arras55626133a_rras
array86317143a_rray
ashram1139053ashram
astral66919283astral
astray95615543astray
atonal6514023atonal
aura45836253a_ura_
aurae54128113a_urae
aural54428963a_ural
aurar54420253a_urar
auras55932563a_uras
aurora6411763aurora_
aurorae739663aurorae
auroral7310473auroral
auroras7311703auroras
avowal1246323avowal
axonal1347653axonal
azonal1568273azonal
bandora1038813bandora_
bandoras1138743bandoras
bora66141633_bora_
boral75831703_boral
boras75938303_boras
borax145918723_borax
bork106933823_bor_k
canola8313623canola_
canolas9313993canolas
cantrap113310283cantrap
caporal11410943caporal
choral115118493choral
cloak115214013clo_ak
coral76033453_coral
cork106635693_cor_k
croak115216633cro_ak
dork96531463_dor_k
engram9310653engram
enorm74415643enor_m
entrap8710563entrap
enwrap1185213enwrap
flora85317103flora_
florae94713883florae
floral94313813floral
floras94715693floras
fora75937393_fora_
foram105124933_foram
foray115023973_foray
fork115930943_for_k
gooral7310463gooral
goral65125753_goral
hoorah124411113hoorah
hooray123011373hooray
hora76136563_hora_
horah117922053_horah
horal86328683_horal
horas86333103_horas
infra838643infra_
inroad737933inroad
inwrap11115903inwrap
ixora1236913ixora_
ixoras1337193ixoras
joram145816983_joram
knock10487963kno_ck
kora86431553_kora_
korai97018523_korai
koras95927113_koras
korat94934433_korat
loral55927823_loral
loran55925093_loran
mandrake1546003mandrake
manor78023933manor__
manorial10311083manorial
manors84420883manor_s
mantra84116093mantra_
mantram114011603mantram
mantrap11379823mantrap
mantras93815863mantras
mayoral1237693mayoral
menorah1247933menorah
mora66641273_mora_
morae75831193_morae
moral75533433_moral
moras76438783_moras
moray105423793_moray
naira5314743naira_
nairas6312783nairas
nanogram1145673nanogram
nark85230063_nar_k
nock106127183_no_ck
nodal64717793_nodal
noma67529463_noma_
nomad86016183_nomad
nomas74726413_nomas
nona46929063_nona_
nonas55126653_nonas
nonoral7313603nonoral
nook85728493_no_ok
nopal75517103_nopal
nor38048823_nor__
nori47133143_nor_i
noria55722183_noria
norias65518203_norias
noris54928273_noris
norm66429813_nor_m
normal83213533_normal
norms76019313_norms
north86018273_north
nota46830773_nota_
notal55221353_notal
nova76518953_nova_
novae85913123_novae
novas85215363_novas
noway111112843_noway
oak76238653__o_ak
ora37250833__ora_
orad56031693__orad
oral47638123__oral
pakora1247283pakora_
pakoras1337473pakoras
pandora1039543pandora_
pandoras11310053pandoras
pangram1239023pangram
panorama1244943panorama
pork106929683_por_k
sanjak1735693san_jak
senora63216163senora_
senoras72714953senoras
shoran94016043shoran
snark95419943snar_k
sneak96016173sn_eak
snook95115573sno_ok
snore55424953snor_e
snored74819543snored
snorer64316763snorer
snores64324323snores
snort54833753snor_t
snorts64116503snorts
soak87227663_so_ak
sora45746913_sora_
soras55041013_soras
sporal82915453sporal
storax1389783storax
stork96819693stor_k
tanbark1337373tanbark
tangram1038083tangram
tantra63713363tantra_
tantras73112093tantras
thorax1638253thorax
tora47545993_tora_
torah87125273_torah
toras55540373_toras
torsk94915773_torsk
troak95213573tro_ak
unbrake13239123unbrake
uncork1239043uncor_k
undraw1037813undraw
unmoral948693unmoral
untrack1338703untrack
unwrap11126323unwrap
work115528843_wor_k
yantra9449623yantra_
yantras10259003yantras

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.373479064.3
2DLD Change Limit1127162845.37620966.5
3Display Results2842840.0933053.8
 (SQL Overall)1786912845.84230587.3
 
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.