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

262 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
alcaic103998(None) 
alcaics1137021alcaics
acmic11312332a_cmic
alcade91111512alcade
alcaide1088452alcaide
alcid85817962alc_id
alkalic13146962alkalic
archaic1438822archaic
arctic10313502arctic
calcic9311872calc_ic
lactic10713492lactic
laic65931562_l_aic
abaci94718843abaci_
abulic106411423abulic
acacia10311353a_cacia
acari75020283a_cari
acarid95017063a_carid
acclaim1345783acclaim
acetic10314503acetic
acid77533393a_c_id
acidic113612133acidic
acinic104713543acinic
aclinic11188973aclinic
acmatic13311693acmatic
acrid86920103a_crid
actin74922553a_ctin
acyclic1345563acyclic
adipic1137263adipic
aecia73819283aec_ia
aecial84817313aecial
aeonic83517043aeonic
affair1234353affair
afraid1049713afraid
again65218113a_gain
agamic113110543agamic
agaric93513623agaric
aggadic1254783aggadic
agnail739523agnail
agnatic10310963agnatic
agonic93515143agonic
agravic1345883agravic
ala312463603al_a__
alack114820063al_ack
alae45643753al_a_e
alamo7418143al_amo
alan46844083al_a_n
aland65526413al_and
alane56135613al_ane
alang66023513al_ang
alanin6317273alanin
alans55636173al_ans
alant55742293al_ant
alar46340073al_a_r
alarm76621423al_arm
alary86123443al_ary
alas46358123al_a_s
alate55340323al_ate
alba68328333alba__
albas75925393alba_s
albata839333albata
albeit8314343albeit
albinic1136853albinic
albitic1139133albitic
alcades101011473alcades
alcaides11117673alcaides
alcalde10104953alcalde
alcayde13103723alcayde
alcazar1843453alcazar
alchemic1745253alchemic
alcids94812293alcids
alcove1178083alcove
aldrin7311243aldrin
alec66430063al__ec
alembic1354773alembic
alevin92511513alevin
alexia132910463alexia
alexin132311483alexin
alfa77624273alfa__
alfaki1385383alfaki
alfakis1475073alfakis
alfas87219043alfa_s
alga57927603alga__
algae65319623alga_e
algal66518213alga_l
algas65624933alga_s
algid75415573al_gid
algin65718763al_gin
algoid83011463algoid
alias55834603alia_s
alibi7514223alibi_
alibis8311073alibis
alif76242133al__if
alit46155693al__it
alkali10127553alkali
alkalin11178173alkalin
alkalis11148783alkalis
alkane104313323alkane
alkie95520033al_kie
alkylic16174233alkylic
allay85620393alla_y
allays94313743allays
allelic9118173allelic
allylic12155843allylic
alma66333023alma__
almah106917253alma_h
almahs118611613almahs
almanac1156033almanac
almas76629773alma_s
alnico877943al_nico
alodia71112453alodia
aloetic9313183aloetic
aloin55227413al_oin
alpaca1047383alpaca
altar55520643alta_r
altars64518153altars
alumin8513543alumin
alway116113923alwa_y
always12409133always
amain74922883a_main
amebic1239103amebic
amidic114012863amidic
aminic104413513aminic
amnic95516233a_mnic
amylic13108703amylic
anemic102713693anemic
anisic8313793anisic
anodic92813133anodic
anomic102516303anomic
anoxic152610673anoxic
antic75728863a_ntic
anuric8812093anuric
aortic8316613aortic
aphasic142810063aphasic
aplitic11311743aplitic
apneic1078623apneic
apraxic1846293apraxic
aquatic1838113aquatic
arabic10312733arabic
arcade91013643arcade
arcadia1039703arcadia
arcana8912583arcana
arcane81216743arcane
archil11611573archil
arctics1138953arctics
areic73219393a_reic
ascarid103910713ascarid
ascaris93613323ascaris
ascetic11310063ascetic
asci66519143asc_i_
ascitic1139313ascitic
asdic83814093a_sdic
aspic95114733a_spic
assai5711543assai_
assail6610153assail
assais6711963assais
astatic9514193astatic
atactic11410083atactic
atavic11189293atavic
ataxic15169203ataxic
atelic8313703atelic
atomic104115603atomic
atonic83420473atonic
atopic103514143atopic
attain6311753attain
attic75618353a_ttic
atwain937813atwain
atypic13337653atypic
aulic74420243a_ulic
auric74521723a_uric
avail8313883a_vail
aviatic1239243aviatic
await85524493a_wait
axenic154210003axenic
axonic154312723axonic
azoic162912063a_zoic
azonic175513153azonic
azotic172711623azotic
bacchic1545813bacchic
baldric12166403baldric
balladic1345333balladic
balsamic1463803balsamic
blain75421793bl_ain
caid77837533__caid
cain65643913__cain
calcar10312753calca_r
calcaria1249523calcaria
calcars11312653calcars
calcific1445023calcific
calcitic1148173calcitic
caloric113413213caloric
calpac123211063calpa_c
calpain11310413calpain
chic115925203__chic
claim95616913cl_aim
cleric10612133cleric
clinic104312793clinic
clitic103315053clitic
clonic104914673clonic
cocain101315013cocain
coccic8298943coccic
cyclic1238033cyclic
dalmatic1348673dalmatic
deltaic1037023deltaic
eclair836813eclair
elain55324703el_ain
falcate12311613falcate
flail85316183fl_ail
flair86114123fl_air
flic96223733fl__ic
galactic13106533galactic
galenic1038693galenic
gallic9411633gal_lic
galvanic1444513galvanic
galyac1235973galya_c
glacis94012133glacis
glair65313553gl_air
halachic1865653halachic
halakic1656653halakic
hectic132311513hectic
ictic9311793_ictic
ileac75814173ilea_c
iliac75013483ilia_c
jalapic1844543jalapic
kalpac14428223kalpa_c
lac510155823_l_a_c
laconic1139883laconic
laich105920713_l_aich
laics76419253_l_aics
laid56439143_l_aid
lain46146283_l_ain
lair45934153_l_air
lanai5319573lanai_
lanais6316793lanais
logic88217833_logic
lotic76420663_lotic
ludic82912803_ludic
lyric104512723_lyric
lytic104513033_lytic
malefic1486323malefic
malic94525653mal__ic
mosaic10311143mosaic
oleic7313333ol_eic
palais8420423pal_ais
palladic1346113palladic
pectic122913873pectic
picnic123410263picnic
picric12309923picric
placid114012543placid
plaice10311553pl_aice
plaid85118303pl_aid
plain74823303pl_ain
plait75631573pl_ait
saccadic1244173saccadic
salic73424713sal__ic
slain54923573sl_ain
tactic10612753tactic
unchic1338643unchic
valeric1238303valeric
vocalic1446943vocalic
volcanic1544773volcanic
voltaic1245453voltaic
vulcanic1543833vulcanic

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 Filter1786911127160.1401276364.3
2DLD Change Limit1127162625.87619182.4
3Display Results2622620.0932817.2
 (SQL Overall)1786912626.10929250.5
 
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.